Combo Box List creation

Forumthread: Combo Box List creation

05.11.2014 20:02:47

Marc

Hello,
I would like to chose from the Combo Box some list items in column A. Once I hit the Add button, those should be lined up under D. So I chose A first and it will go to D1. Than I chose B and it will go to D2.
Thanks,
Marc
https://www.herber.de/bbs/user/93579.xlsx

2
Beiträge zum Forumthread

Beiträge zu diesem Forumthread

Betreff

Datum

Anwender

AW: Combo Box List creation

05.11.2014 20:17:06

Uduuh
AW: Combo Box List creation

05.11.2014 21:15:29

Marc

AW: Combo Box List creation

05.11.2014 20:17:06

Uduuh

Hello,
sorry for my mistake of yesterday. This does what you want:

Private Sub CommandButton1_Click()
Dim lRow As Long
lRow = Cells(Rows.Count, 4).End(xlUp).Row
If Cells(lRow, 4)  "" Then lRow = lRow + 1
Cells(lRow, 4) = ComboBox1
End Sub

Gruß
Rudi

AW: Combo Box List creation

05.11.2014 21:15:29

Marc

Thank you. Great!
Marc

Forumthread: Combo Box List creation

2 Beiträge zum Forumthread Beiträge zu diesem Forumthread

2
Beiträge zum Forumthread

Beiträge zu diesem Forumthread