Combo box values based on other combo box value

Combo box values based on other combo box value

Post by SkNhbnlvbm » Thu, 07 Apr 2005 02:33:05


I have an excel sheet that I would like to have 3 to 4 combo boxes (possibly
list boxes, I haven't decides yet) that will relate to each other.

First, Is there a way in the code (not in cells on the sheet) to set the
values that the first combo box uses?

Second, After the user selects a value from the first combo box, say it's
"Chevy", the next combo box only has the values, 2500, 2500HD, & 3500HD. If
the user selected Ford, F150, F250, and F350 are the only items in the list.

Is this possible in excel?
 
 
 

Combo box values based on other combo box value

Post by Ron de Bru » Thu, 07 Apr 2005 02:41:55

Why don't you use Data validation ?
http://www.yqcomputer.com/


--
Regards Ron de Bruin
http://www.yqcomputer.com/