Limit entry data

S

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
 
B

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).
 
S

smi

Thank you Sir, it work great.

Chip Pearson said:
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 [email protected]
Click to expand...
 
Top