| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yes and No
Joerg wrote:
Dragan, you already have a list:Yes and No. These are 2 values, Excel regards this as a list. Try to follow Paul's advice and use Data = Validation =Settings. In the 'Allow' box, choose 'List'. You will see a box called "source'. Directly input into this box all values that you want to allow, separated by commas, e.g Yes,No Cheers, Joerg "Dragan Ristic" wrote in message ... Paul B wrote: Dragan, data validation, allow, list, source Yes, No is that what you want? No, I don't need list. Only I want validation that allow user to input in cell Yes or No value. Sorry on my bad English. OK, Thanks. |
Threaded Mode
