Using combo box

[azblinds]

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

 

[AndrewArmstrong]

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