Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same Items in 3 different Combo Boxes
I have three Combo Boxes in a UserForm that I need to display all 50 state
initials. I usually write my code like this: Private Sub UserForm_Initialize() With cboCustomerST .AddItem "GA" .AddItem "TN" .AddItem "NY" 'list all other state End With End Sub Is there a faster way to do this with 2 other combo boxes instead writing code for each combo box? Thanks in Advance, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
List boxes/combo boxes | Excel Programming |