Hi,
I want to read the values of the drop-down (it is created using Data Validation --> List )and compare whether the pasted values match with the values in the drop-down.
For example , I have for Cell A1 drop-down created using the Data validation List , values are {Clerical , Manager and Professional} . I want to check through VBA Code whether the values pasted in the cell A1 match with those 3 values, if not an error message should display. Please help.
Thanks
Mounika
Bookmarks