Using combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

azblinds - 31 Jul 2008 15:33 GMT

I have a Userform called CustomerInfo. I also have a Combo box called
cbCustomer and 7 Textboxes. I would like to populate the Combo box
from a spreadsheet with a list of customer names and populate the 7
textboxes with Address, Phone, etc.

I don't have much VBA knowledge and need help with the coding.

Thanks
dave

Reply to this Message

AndrewArmstrong - 31 Jul 2008 15:57 GMT

Use something like this:

Private Sub UserForm_Activate()

'Clear Combobox
ComboBox2.Clear

'Add data from sheet
ComboBox2.AddItem Range("d11")
ComboBox2.AddItem Range("d12")
ComboBox2.AddItem Range("d13")

End Sub

Reply to this Message