1st drop down menu must be selected before moving on...how?
Posted by Bundy on January 26, 2002 2:40 PM
I have 3 drop down menus on a sheet and the 2nd menu must not be selectable before the 1st is selected and the 3rd menu must not be selectable before the 2nd is selected.
How would I do this.
Thanks
Posted by Jacob on January 26, 2002 6:31 PM
Hi
On the userform_initialize set listbox 2 and 3 .enabled to false
Then on the listbox1_change set listbox2.enabled = true and then on listbox2_chahnge repeat for listbox3
HTH
Jacob
Posted by Bundy on January 27, 2002 3:30 AM
Would I be able to do this if the drop down menus were on a excel sheet and not on a userform?
