Drop down list based on values in two cells

February 24, 2020 at 00:09:36
Specs: Windows 10
I want to offer a drop down list to the user in C1, if A1 is not blank and B1 is empty/blank. How can I do it with data validation?

See More: Drop down list based on values in two cells

Reply ↓  Report •

#1
February 24, 2020 at 06:10:03
If you are willing to include VBA in your workbook, we can make the drop-down list available based on your criteria. If we go this route, we would need some more information so we can determine the best way to trigger the code to create/delete the drop down. e.g. How does the data in A1 and B1 get there: direct user input, drop down lists, formula based, something else?

Another option is to not use VBA and always have a drop down in C1 but change the choices based on the contents of A1 and B1. e.g. display N/A or something similar and not offer any other choices except when you want it to.

Please keep in mind that we can't see your workbook from where we are sitting nor do we know anything about your work processes. The more specific you can be in answering our questions, the easier it will be to come up with a viable solution.

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


Reply ↓  Report •
Related Solutions


Ask Question