I have VBA code to force the user to select values from drop down lists when a value is selected from another drop down list. When "NONE" is selected from the first list the other lists are greyed out and set to N/A. When "USE BY DATE" is selected from the first list, the user is forced to select values from the other three lists. The code works in excel 2003 but when I run it on 2007 (at work), I get all kinds of debug errors and crashes. I am not very proficient with excel programming so I am hoping you guys can tell me why this is happening or clean up the code for me. Thanks in advance for your time and knowledge.
Please Login or Register to view this content.
Bookmarks