PC Review


Reply
Thread Tools Rate Thread

Data validation on combo boxes

 
 
Pristan
Guest
Posts: n/a
 
      19th Jun 2008
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?
 
Reply With Quote
 
 
 
 
DaveO
Guest
Posts: n/a
 
      19th Jun 2008
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exact Validation Rules for a combo boxes PJ Microsoft Access Form Coding 4 17th Sep 2007 06:58 PM
Data validation boxes, outputting a final number from the boxes =?Utf-8?B?TURI?= Microsoft Excel Misc 1 16th Nov 2006 12:41 AM
validation list or combo boxes with hyperlinks =?Utf-8?B?Z2VvcmFuYQ==?= Microsoft Excel Misc 2 17th Apr 2006 01:32 PM
data access page combo boxes and test boxes not visable or print =?Utf-8?B?Y3RhejJkYXk=?= Microsoft Access 0 26th Jul 2005 02:31 AM
validation combo boxes not working =?Utf-8?B?c3RldmUgYWxjb2Nr?= Microsoft Excel Worksheet Functions 2 29th May 2005 06:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:33 AM.