limit data entry to predetermined list

[william bonney]

I have seen this done before, but I don't remember how to do it.

Note - I am trying to reconstruct how to do this without using combo
boxes.

I have a range of data - say 4 rows in column E that contain names that
I want to put in column A.

I want to enter data in column A, but when I do I want it to allow me
only to select a data element from one of the four rows in column E.
Sort of a limit to list operation.

If I recall correctly, when placing the cursor in one of the cells in
column A it would show me a drop down list of the data in column E that
I could choose from.

And it was not done using combo boxes.

Any help in doing this??

thanks in advance

 

[RagDyer]

You could use data validation to make your drop down list.
Check Debra's web page for the procedure.

http://www.contextures.com/xlDataVal01.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[william bonney]

Well, thanks for the venue.

I actually read down a few posts and picked up my answer under data
validation.

thanks

william bonney

 

[John Wilson]

William,

Data Validation is probably what you're looking for.
Try here:

http://www.contextures.com/xlDataVal01.html

John