Dox,

Probably the easiest thing to do is use Data Validation. Select the cells
you want the drop down box to be in. Choose Data, Validation.

Once there, the first tab will say "Settings". In the "Allow" box, choose
"List". In the source box, type "Yes, No" - without the quotes. You'll
want in-cell dropdown checked. Whether you'll allow blanks is up to you.
The "Error Alert" tab describes the behavior if the user enters anything
other than yes or no.

The bad news is that it's case sensitive. Maybe someone else here knows how
to get around that. Also, unlike combo boxes the user will often have to
type the entire word and not just a "y" or an "n". I think that in order to
any better you've got to use a macro.


"Dox" wrote:

I am creating an Excel worksheet for my hotel that updates the status of
Microwaves and Refridgerators in the rooms. We only have enough for 50% of
the hotel so they move around often. We currently scribble on a piece of
paper which rooms do/do not have micro/fridges. This is tedious, messy, and
unreliable. Does anyone know how I can create a drop-down box so that yes/no
can be specified for each room? I think this would help hotel productivity
as well as increase guest satisfaction.

Thank you in advance for any help that can be given.