Thread: Yes and No
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joerg Joerg is offline
external usenet poster
 
Posts: 138
Default Yes and No

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.