matching exact values

**hey1000** · 06-14-2010, 04:01 PM

i have figured out the empty cell issue. now i was wondering how i could match the data in a textfield on a userform with the cell data exactly.

As of right now if partial data is matched it returns an error. i would like it to return an error only if the exact data matches.

Please Login or Register  to view this content.

thank you again for your help

**DonkeyOte** · 06-14-2010, 05:00 PM

Without having had a chance to look at the code in depth I would suggest first reviewing the Help files re: Find - specifically use of LookAt property (xlWhole)

(edit: and if nec. see also MatchCase)