Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a form and when I initialize the form I need multiple combo
boxes to fill in with the same data. Is there an easier way then doing .additem for each one? My code below. Thanks Jay Private Sub UserForm_Initialize() With CmbxFirst 'this loads the combo .AddItem "LDC" .AddItem "DC" .AddItem "DB" .AddItem "LDDB" .AddItem "XmasDB" .AddItem "XmasLDDB" .AddItem "XmasDC" .AddItem "XmasLDC" .AddItem "No Die" .AddItem "Same Die As" End With With CmbxSecond 'this loads the combo .AddItem "LDC" .AddItem "DC" .AddItem "DB" .AddItem "LDDB" .AddItem "XmasDB" .AddItem "XmasLDDB" .AddItem "XmasDC" .AddItem "XmasLDC" .AddItem "No Die" .AddItem "Same Die As" End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
Disable and enable dropdown combobox(Form Control) | Excel Discussion (Misc queries) | |||
link form combobox | Excel Worksheet Functions | |||
VBA Form ComboBox question | Excel Worksheet Functions |