Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Okay.. here's the deal, i have a user form in excel that
gathers information. In one section there is a series of six combo boxes. What i have been trying to do is have code in the UserForm_Initialize() sub that adds items to the combo boxes. All six combo boxes need the same information added to them. what i would like to do is something like: for each X in (1,2,3,4,5,6) with Me.ComboBoxX .AddItem "a" .AddItem "b" end with next trying to get it to go through all 6 boxes.. but this is not working and i cant figure out how to get it to work without reapeating the .AddItem list for each and every box. is there a faster way to do it? -keaven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
multiple combo boxes | Excel Discussion (Misc queries) | |||
Multiple combo boxes with unique duplicates showing only | New Users to Excel | |||
Problem Adding new Combo Boxes | Excel Discussion (Misc queries) | |||
multiple combo boxes | Excel Discussion (Misc queries) |