Limit entry data

  • Thread starter Thread starter smi
  • Start date Start date
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
 
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).
 
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 (e-mail address removed)
Click to expand...
 
Back
Top