Combo Boxes

[Lilbit]

Someone sent me an Excel document where each of the cells in I1:I312 are
combo boxes. When you click off of those cells, the down arrow
disappears. The list for the combo boxes are cells AA1 and AB1 (AA1 is
New and AB1 is Existing). Please explain how this was done? Also, can
you please tell me if it is possible to make New and Existing autocorrect
entries. So even though the choices are New and Existing, if you hit N,
New appears, and if you hit E, Existing appears. Thanks!!

 

[Dave Peterson]

It sounds like Data|Validation.

Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

 

[Bob Phillips]

Data Validation (menu Data>Validation). See
http://www.contextures.com/xlDataVal01.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Lilbit]

Thanks Dave and Bob!!