Datavalidation,allow list and put

SSTL,ALUM,COPPER

in the source box, that will actually give you a dropdown to select from, if
you just want to validate against typing something else you need to
de-select in cell dropdown from the validation dialogue box

note that this is case sensitive, if you don't want that use custom from
allow then in the source use

=OR(I7="SSTL",I7="ALUM",I7="COPPER")

which is not case sensitive

all this can be bypassed by copying and pasting other values

--
Regards,

Peo Sjoblom






"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.