Hi,
I want to create a data sheet in which the operator must enter a text name in one of the columns . However, I only want to allow the operator to be able to enter a predefined list of text names that I have set up in advance.

For example:
the heading of the column is "sales". When entering data into that column, I don't want the operator to be able to enter just anything but rather they are only allowed to enter (electronics,electrical, computer, and mechanical).

I understand taht one can use define name lists but I am really struggling to find help with how to define a name using text rather than working with numbers.

Thank you to anyone who can help me with this.

EggHeadCafe - Software Developer Portal of Choice
Solution to the Annoying Flickering Problem When Updating Textboxes
http://www.eggheadcafe.com/tutorials...-annoying.aspx