View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DaveO[_2_] DaveO[_2_] is offline
external usenet poster
 
Posts: 46
Default 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