Hi,
I was wondering if anyone can help me out with this.
I have an in-cell dropdown list that I set up via Data/Validation menu.
All values in the list are uppercase. For example, "VISA, MASTER,
DISCOVER". So, user can either choose from the list or manually type
in the value.
When user manually type in a value, I have code in Worksheet_Change()
that will turn the value into uppercase. What I would like is to take
this value and validate against the values from the dropdown list.
Any help would be much appreciated.
Thanks.
Bookmarks