AW: Werte aus Textboxen in ListBox
02.08.2005 22:38:08
Uwe
Hallo Christoph,
irgendwas mach ich falsch. Aber so geht es nicht.
In der ListBox kommt nichts an!
Ist der Code denn so falsch?
Option Explicit
Private Sub CommandButton1_Click()
With Me
.ListBox1.Clear
.ListBox1.AddItem .TextBox1
.ListBox1.AddItem .TextBox2
.ListBox1.AddItem .TextBox3
.ListBox1.AddItem .TextBox4
.ListBox1.AddItem .TextBox5
.ListBox1.AddItem .TextBox6
.ListBox1.AddItem .TextBox7
'...usw
End With
Set Frm = Tabelle2
Sheets("Formular").Activate
Range("B65535").End(xlUp).Offset(1, 0).Select
With Frm
ActiveCell.Value = UserForm2.TextBox2
End With
Set Frm = Tabelle2
Sheets("Formular").Activate
Range("D65535").End(xlUp).Offset(1, 0).Select
With Frm
ActiveCell.Value = UserForm2.TextBox3
End With
Set Frm = Tabelle2
Sheets("Formular").Activate
Range("F65535").End(xlUp).Offset(1, 0).Select
With Frm
ActiveCell.Value = UserForm2.TextBox4
End With
Set Frm = Tabelle2
Sheets("Formular").Activate
Range("h65535").End(xlUp).Offset(1, 0).Select
With Frm
ActiveCell.Value = UserForm2.TextBox5
End With
Set Frm = Tabelle2
Sheets("Formular").Activate
Range("n65535").End(xlUp).Offset(1, 0).Select
With Frm
ActiveCell.Value = UserForm2.TextBox6
End With
Set Frm = Tabelle2
Sheets("Formular").Activate
Range("o65535").End(xlUp).Offset(1, 0).Select
With Frm
ActiveCell.Value = UserForm2.TextBox7
End With
End
End Sub
Gruß Uwe