Hello to all,
Is there a way of having the drop down list in the cells that require validation when the criteria used is "Custom"?
Many thanks for any kind help.
Octavio
Hello to all,
Is there a way of having the drop down list in the cells that require validation when the criteria used is "Custom"?
Many thanks for any kind help.
Octavio
Last edited by oteixeira; 10-18-2022 at 07:01 PM.
Not really sure what you mean by "custom", but There is nothing magical about a drop down (data validation), it acts in the exact same way as if you had entered the data manually, and excel formulas only see the data in the cell as if it had been entered manually.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello Ford,
By "custom" I mean that a formula is used to validate the data entry. Thank you for the code idea, I was already figuring that is the way to solve the problem.
Octavio
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks