Match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Partially match 2 lists 1
Excel Excel conundrum - I've tried and tried, but 10
Match Text with List 1
Excel Is this possible?? 3
MATCH OFFSET LIST VALIDATION 2
Match formula 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top