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

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

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