Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting list to populate combo box
Hi
We have a fleet of 400 buses which consists of 3 different types of vehicle that are distinguishable by their fleet numbers. I have created a userform for data entry and the fleet numbers are input via a combo box. What I would like is that having entered a route number in the form the combo box would only show the fleet numbers available for that route. Is it possible to vary the RowSource property using different lists depending on the route selected. Thanx for your help. -- Al |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting list to populate combo box
Check out this link...
http://www.xldynamic.com/source/xld.Dropdowns.html -- HTH... Jim Thomlinson "gramps" wrote: Hi We have a fleet of 400 buses which consists of 3 different types of vehicle that are distinguishable by their fleet numbers. I have created a userform for data entry and the fleet numbers are input via a combo box. What I would like is that having entered a route number in the form the combo box would only show the fleet numbers available for that route. Is it possible to vary the RowSource property using different lists depending on the route selected. Thanx for your help. -- Al |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting list to populate combo box
Whitout VBA: http://boisgontierjacques.free.fr/fi...DV_Cascade.xls http://boisgontierjacques.free.fr/fi...lesCascade.xls JB http://boisgontierjacques.free.fr On 10 août, 22:56, gramps wrote: Hi We have a fleet of 400 buses which consists of 3 different types of vehicle that are distinguishable by their fleet numbers. I have created a userform for data entry and the fleet numbers are input via a combo box. What I would like is that having entered a route number in the form the combo box would only show the fleet numbers available for that route. Is it possible to vary the RowSource property using different lists depending on the route selected. Thanx for your help. -- Al |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
populate combo box | Excel Discussion (Misc queries) | |||
Populate a combo box | Excel Discussion (Misc queries) | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Populate List / Combo Box | Excel Discussion (Misc queries) | |||
Populate a combo Box | Excel Worksheet Functions |