ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pulldown boxes (https://www.excelbanter.com/excel-programming/272615-re-pulldown-boxes.html)

Debra Dalgleish[_2_]

pulldown boxes
 
You can use Data Validation:

1. Select the cell(s) in which you want the list
2. Choose DataValidation.
3. From the Allow drop-down list, choose List
4. In the Source box, type: Yes, No
5. Click OK.

Note: Users will be required to match the case in the list, (e.g. "no"
will be an invalid entry because of the lower case letters)

You can also refer to a list on worksheet, which is not case sensitive.
There are some instructions he

http://www.contextures.com/xlDataVal01.html

david wrote:
I was wondering if it was possible to make a pulldown in a
cell. So, that I could make them select from the pulldown
menu choices. For example in a certain cell, I just want
them to select yes or no.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com