Advanced Validation Assistance Needed
I am working on a spreadsheet where I have validation requirements in one cell depending on what is in a preceeding cell. I know how to use named ranges with the Indirect() formula, but it isn't working in this instance.
If a user selects "Option 1" in cell A1, then in cell B1, they are limited to selecting from items in the named range opt1. No issues there.
However, if the user selects "Option 2" in cell A1, they should be able to enter any value into cell B1. This is where I am having trouble figuring out how to handle. Is this even possible?
Thanks in advance to anyone who can help.
In Data Validation window go to the Error tab, and uncheck "show error alert after...."
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Doing that allows the user to enter any value into cell B1 regardless of what is in cell A1. That is not what I want.
Originally Posted by NBVC
I don't think it will be possible to have that combination unless somebody can figure it out using VBA events....
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks