MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?