How do a set a parameter in cell - choose A or B options?

[Guest]

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.

 

[Don Guillett]

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

 

[Guest]

Look in the Help file for

Create a drop-down list from a range of cells

 

[Peo Sjoblom]

Data>validation,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