Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting Combo boxes to change options based on other Combo boxes. Ancient Wolf New Users to Excel 1 March 27th 09 06:29 PM
Data validation boxes, outputting a final number from the boxes MDH Excel Discussion (Misc queries) 1 November 16th 06 12:41 AM
Data validation with validation lists and combo boxs Keith Excel Discussion (Misc queries) 1 October 12th 06 11:08 AM
validation list or combo boxes with hyperlinks georana Excel Discussion (Misc queries) 2 April 17th 06 01:32 PM
validation combo boxes not working steve alcock Excel Worksheet Functions 2 May 29th 05 06:21 PM


All times are GMT +1. The time now is 09:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"