limit data entry to predetermined list

  • Thread starter Thread starter william bonney
  • Start date Start date
W

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
 
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!
==============================================
 
Well, thanks for the venue.

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

thanks

william bonney
 
Back
Top