Code schneller machen
07.07.2008 18:12:00
Heiko
ich habe hier diesen Code. Er klappt einwandfrei. Es dauert nur eine zeit bis er die Daten in die vorgegebenen Zellen eingetragen hat. Gibt es eine möglichkeit den Code schneller zu machen?
Gruß Heiko
Hier der Code:
Private Sub CommandButton1_Click()
'Spiel 1
[cm4].Value = TextBox1.Value
[cn4].Value = TextBox2.Value
[co4].Value = TextBox3.Value
[cp4].Value = TextBox4.Value
[cq4].Value = TextBox5.Value
[cr4].Value = TextBox6.Value
'Spiel 2
[cm6].Value = TextBox7.Value
[cn6].Value = TextBox8.Value
[co6].Value = TextBox9.Value
[cp6].Value = TextBox10.Value
[cq6].Value = TextBox11.Value
[cr6].Value = TextBox12.Value
'Spiel 3
[cm8].Value = TextBox13.Value
[cn8].Value = TextBox14.Value
[co8].Value = TextBox15.Value
[cp8].Value = TextBox16.Value
[cq8].Value = TextBox17.Value
[cr8].Value = TextBox18.Value
'Spiel 4
[cm10].Value = TextBox19.Value
[cn10].Value = TextBox20.Value
[co10].Value = TextBox21.Value
[cp10].Value = TextBox22.Value
[cq10].Value = TextBox23.Value
[cr10].Value = TextBox24.Value
'Spiel 5
[cm12].Value = TextBox25.Value
[cn12].Value = TextBox26.Value
[co12].Value = TextBox27.Value
[cp12].Value = TextBox28.Value
[cq12].Value = TextBox29.Value
[cr12].Value = TextBox30.Value
'Spiel 6
[cm14].Value = TextBox31.Value
[cn14].Value = TextBox32.Value
[co14].Value = TextBox33.Value
[cp14].Value = TextBox34.Value
[cq14].Value = TextBox35.Value
[cr14].Value = TextBox36.Value
'Spiel 7
[cm16].Value = TextBox37.Value
[cn16].Value = TextBox38.Value
[co16].Value = TextBox39.Value
[cp16].Value = TextBox40.Value
[cq16].Value = TextBox41.Value
[cr16].Value = TextBox42.Value
'Spiel 8
[cm18].Value = TextBox43.Value
[cn18].Value = TextBox44.Value
[co18].Value = TextBox45.Value
[cp18].Value = TextBox46.Value
[cq18].Value = TextBox47.Value
[cr18].Value = TextBox48.Value
'Spiel 9
[cm20].Value = TextBox49.Value
[cn20].Value = TextBox50.Value
[co20].Value = TextBox51.Value
[cp20].Value = TextBox52.Value
[cq20].Value = TextBox53.Value
[cr20].Value = TextBox54.Value
'Spiel 10
[cm22].Value = TextBox55.Value
[cn22].Value = TextBox56.Value
[co22].Value = TextBox57.Value
[cp22].Value = TextBox58.Value
[cq22].Value = TextBox59.Value
[cr22].Value = TextBox60.Value
'Spiel 11
[cm24].Value = TextBox61.Value
[cn24].Value = TextBox62.Value
[co24].Value = TextBox63.Value
[cp24].Value = TextBox64.Value
[cq24].Value = TextBox65.Value
[cr24].Value = TextBox66.Value
'Spiel 12
[cm26].Value = TextBox67.Value
[cn26].Value = TextBox68.Value
[co26].Value = TextBox69.Value
[cp26].Value = TextBox70.Value
[cq26].Value = TextBox71.Value
[cr26].Value = TextBox72.Value
Range("c6").Select
Unload Me
End Sub