• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 841
  • Last Modified:

Yes No data validation

Experts,
Can you have a data validation rule that only allows for a Yes or No value
0
Frank Freese
Asked:
Frank Freese
  • 4
  • 3
  • 3
1 Solution
 
TonyWongCommented:
Yes you can if you choose 'List' as your allowed values under Data Validation and reference to the cells which contain the 'Yes' and 'No' as your validation list.
0
 
Rory ArchibaldCommented:
Or just enter:
Yes, No
in the Source box.
0
 
Frank FreeseAuthor Commented:
can it be done w/o a list box with code
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Rory ArchibaldCommented:
You don;t have to have a listbox - you can still use the data validation?
If you really want code for some reason then use the Change event of the worksheet and check the cell value.
0
 
TonyWongCommented:
Yes, rorya's solution is the one you want :)
0
 
Frank FreeseAuthor Commented:
is a source box the same as a cell
0
 
TonyWongCommented:
No, rorya is referring to the 'Source' field within the Data Validation pop up when you choose 'List' from the 'Allow' part.
0
 
Rory ArchibaldCommented:
No - in the Data Validation dialog, change the Allow option to List, then type
Yes, No
in the Source textbox, and uncheck the In-cell dropdown option.
Note: this will be case sensitive so you may want to use a source range instead.
0
 
Frank FreeseAuthor Commented:
thank you
0
 
Rory ArchibaldCommented:
I think a points split would be fair here as TonyWong's first answer directly addressed your initial question - would you like me to get this reopened so you can reallocate the points?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now