Creating 'yes' or 'no' option in a designated cell
 

Hi, hopefully a simple question...

I'd like a cell in my sheet - say b7 - to allow the user 2 options, one
being 'yes' the other being 'no'. I do not want the user to be able to
ignore the box and if yes is not actively selected then the cell should
display 'no'.

I presume this is a simple drop down list which shouldn't be hard to
create but the excel help function has me bamboozled so i turn, once
again, to your collective genius! Many thanks in advance, your help is
lways much appreciated.


---
Message posted from http://www.ExcelForum.com/

Creating 'yes' or 'no' option in a designated cell
 

The simplest way is to add a combobox and link it to a hidden column.
To do that, edit the combobox's properties and make the ListFillRange
Z1:Z2 (for example) put "NO" in Z1 and YES in Z2 and hide column Z.
When I did this the combobox was blank until I selected one of the
options. After that BLANK was not an option. - Pikus


---
Message posted from http://www.ExcelForum.com/

Creating 'yes' or 'no' option in a designated cell
 

Take a look at Data|Validation.

You can type in your allowable values once you choose List.

Start off saving the file with "no" showing. And use an adjacent cell with a
formula like:

=if(a1<"","","<--Warning Must be Yes/No")
And format it big bold red letters.



ian123 wrote:

Hi, hopefully a simple question...

I'd like a cell in my sheet - say b7 - to allow the user 2 options, one
being 'yes' the other being 'no'. I do not want the user to be able to
ignore the box and if yes is not actively selected then the cell should
display 'no'.

I presume this is a simple drop down list which shouldn't be hard to
create but the excel help function has me bamboozled so i turn, once
again, to your collective genius! Many thanks in advance, your help is
lways much appreciated.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson