i have this code to populate a combobox
Dim c As Range
With Sheets("REGISTER")
For Each c In .Range("B8", .Range("B" & Rows.Count).End(xlUp))
If c.Value <> "" Then ComboBox_members.AddItem c.Value
Next c
End With
but i want to populate a combobox with both data from b column and c column.
how do i do this?
in b column i have first name
in c column i have last name
in the combobox i want to show full name
and it is important that the combobox updates when another row of names is added... so i cant have fix range.
Bookmarks