Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a User Form that has a combo Box on it. Is it possible for the Combo
Box to get it's Data from a Work Sheet in the same Work Book as the User Form instead of doing in Code as follows: With Me.Engineer_2 .AddItem "1" .AddItem "2" .AddItem "3" .AddItem "4" .AddItem "5" .AddItem "6" End With The reason I ask is because I would like to be able to set it up as follows: Combo Box 1 = Customer 1 Combo Box 2 = State Combo Box 3 = Site ID User Picks the Customer, then the State for that Customer, then the Site ID for that Customer. Each State (9-States) has about 450 Sites for each of the 4 Customers, so writing it in Code would take forever. Plus I already have all the Data in a Work Book, so all I have to do is add a Sheet for each customer and Copy & Paste the Data. I want to use the Comboxes as a process of elimanation to narrow it down. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
If excel sheet protected, combo boxes won't work | Excel Discussion (Misc queries) | |||
Clear a set of combo boxes after a Submit of data to a new sheet. | Excel Worksheet Functions | |||
Flaky combo boxes. Work around? | Excel Programming | |||
Flaky combo boxes. Work around? | Excel Programming |