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/