Archive of Mr Excel Message Board

Back to Controls in Excel archive index
Back to archive home

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

Re: 1st drop down menu must be selected before moving on...how?

Posted by Jacob on January 26, 2002 6:31 PM

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

Re: 1st drop down menu must be selected before moving on...how?

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?

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.