Match

H

Howard

I have a list of 26 teams. If I type a name into a cell and it doesn't
exactly match one of the names in the list, I would like an error message to
pop-up. Is there a VBA procedure that would do that validation?
Thanks,
 
C

Chip Pearson

You can use Data Validation to do this. Select the cell in which
you will type the name, then choose Validation from the Data
menu. In that dialog, choose List from the Allow list, and enter
the range containing your team names.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top