ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I set up a cell with a pull down list? (https://www.excelbanter.com/excel-discussion-misc-queries/51860-how-do-i-set-up-cell-pull-down-list.html)

sick and sleepy

How do I set up a cell with a pull down list?
 
I am trying to set up a Startup form. I would like the form to have pull
downs, for the employee to just be able to click and pick the correct option.
Some could be True and False pull downs, other would have specific options
for the setting. How do you build a spreed sheet with these type of pull
downs?

Dave Peterson

How do I set up a cell with a pull down list?
 
The simplest way might be to use data|validation.

Debra Dalgleish has some instructions at:
http://contextures.com/xlDataVal01.html

Do you mean a worksheet designed to look like a form? I'm guessing that you do.

sick and sleepy wrote:

I am trying to set up a Startup form. I would like the form to have pull
downs, for the employee to just be able to click and pick the correct option.
Some could be True and False pull downs, other would have specific options
for the setting. How do you build a spreed sheet with these type of pull
downs?


--

Dave Peterson


All times are GMT +1. The time now is 12:46 PM.

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