Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using combo box
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using combo box
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate one combo box based on the selection of another combo box | Excel Programming | |||
Excel VBA Combo Box Populating dependent on other combo box choices | Excel Programming | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |