Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation on combo boxes
I have created a simple Yes / No combo box that links to a cell in another
spreadsheet. However it is possible for people entering information in the combo box to type something other than Yes / No. How can I require that the information in the combo box is either Yes / No? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation on combo boxes
One way:
In an out of the way spot, call it cells A1 and A2, enter the word Yes in A1 and No in A2. Create a named range called YesNo that refers to A1:A2. In place of the combo box, highlight the cell and click Data Validation; in the Allow box select List and in the Source box enter =YesNo This will limit user inputs to either Yes or No. Just to avoid future gotchas if you use this again, if you include a blank space in your range of cells, users will be able to enter anything in that cell. Dave O Eschew obfuscation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
validation list or combo boxes with hyperlinks | Excel Discussion (Misc queries) | |||
validation combo boxes not working | Excel Worksheet Functions |