Look in the help index for data validation or goto
http://www.contextures.com/tiptech.html


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"cara8236" wrote in message
...
I have an Excel Spreadsheet. I want to create a form where in a designated
cell - another user can only choose pre-designated options to type into
that
cell. How do I do that? Example: Cell A1 - User can choose to type in:
SSTL or ALUM or COPPER. The user would not be able to type any other
value
in cell A1.