Yes/No Drop Down Box

[Althas]

Hi all

Sorry to post what must be a simple to do question, but for the life of me I can not work it out. I have done a search on the forums but can not see what I need to know

Basically I have never created a drop down box before, but want to insert one into a worksheet with a simple Yes/No option for the user to select

That simple, but I feel a bit silly asking

Thanks all in advance

[Carim]

Hi,

Attached is an example ...

What you are looking for is the first example Data Validation ...

HTH
Carim

[Althas]

Perfect Carim, Thanks a Million

If anyone has a link to, or some instructions on how to actually do this, then please post here, as I would like to know to add to my Excel knowledge

Thanks again

[Carim]

Hi again,

Data Validation
Allow ... List
Source Yes, No
Ok

HTH
Carim

[Althas]

Wonderful

Simple when you know how

Thanks again Carim

[Carim]

You are welcome ...

Thanks for the feedback

Carim