Drop down list limit to list

[Dropdown3]

How can I limit the people using my spreadsheet to the list of client
names listed? My list works great, but instead of selecting Gino's from
the drop down list, they type in "Ginos." I've search Data Validation
and see the Warning message options, but not a limit to list option.

Also, I know if I have "Gino's" in the column cell once, then the next
time someone types "G" in a cell that "Gino's" will pop up. Is there a
way to have this happen the first time some types a "G?"

-Chuck-

 

[Dropdown3]

I have distributed the worksheet the appropriate persons, that's not the
issue. The problem I'm having is limiting their options to only the
clients listed in the list box.

-Chuck-

 

[Dave Peterson]

How did you create the dropdown?

If you used a combobox from the control toolbox toolbar, then change the .style
to fmStyledropdownlist.

If you use data|validation, make sure that you stop any invalid entry.

If you used something else, then you'll have to share that.

 

[Debra Dalgleish]

And make sure there aren't any blank cells in the source list, or people
will be able to type any entry in the cell with data validation.