ExcelBanter - limit choice in cell to one of two values;

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - limit choice in cell to one of two values; (https://www.excelbanter.com/excel-discussion-misc-queries/13948-limit-choice-cell-one-two-values%3B.html)

limit choice in cell to one of two values;

I have a cell where I want the user to ONLY to be able to
input the number "1" or "4".

Any help out there?

Otto Moehrbach

Use Data Validation. Select List and type 1,4. HTH Otto
wrote in message
...
I have a cell where I want the user to ONLY to be able to
input the number "1" or "4".

Any help out there?

galimi

Data, Validation, List

1,4

http://HelpExcel.com

" wrote:

I have a cell where I want the user to ONLY to be able to
input the number "1" or "4".

Any help out there?

JE McGimpsey

Check out Validation in XL Help.

In article ,
wrote:

I have a cell where I want the user to ONLY to be able to
input the number "1" or "4".

All times are GMT +1. The time now is 02:21 AM.