Excel Data Validation IF statements

March 14, 2012 at 18:42:15
Specs: Macintosh
I need to set up some conditional with data validation. If my value in A1 is "BillsFixed" I have a drop down list in B1 that provides all of the fixed bill options. However if in cell A1 "BillsVariable" is selected instead of BillsFixed I don't want a drop down menu to appear in cell B1, allowing the user to enter what the variable bill actually is. How is this possible?

See More: Excel Data Validation IF statements

March 15, 2012 at 06:45:22
It is possible by using a WorksheetChange macro that will monitor A1 and add or delete the DropDown as required.

See this thread, especially Response # 3 for example code.


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question