Limit entry data

[smi]

Hello,
Please help. I am using Excel 97 with Win 95.
How to limit the user to enter either "HO" or "CO" to cell A1, nothing else.
Thank you for your time.
Long

 

[Bradley Dawson]

In the Data>Validation menu you could also select 'List" from the allow
drop-down and
type "HO, CO" in the Source box (without quotes).

 

[smi]

Thank you Sir, it work great.

Long,

You can use the Validation tool from the Data menu. Select the cell(s) you
want to restrict, then go to the Data menu, and choose Validation. There,
choose 'Custom' from the Allow list, and enter the formula

=OR(A1="HO",A1="CO")

in the formula box. Change the A1 reference to the first cell you selected.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com (e-mail address removed)