How can I create a Drop-down cell?

[Guest]

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.

 

[Guest]

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.

 

[Debra Dalgleish]

If you create a delimited list, by typing the entries in the Data
Validation dialog box, it's case sensitive.
Instead, you can type the list on a worksheet, then name the range that
contains the list. In the data validation dialog box, refer to the list
name, e.g.: =MyList

There are instructions here:

http://www.contextures.com/xlDataVal01.html

 

[Guest]

Debra,

Cool! I didn't know you could get case insensitivity. The link is great
too. Thanks.

 

[RagDyeR]

What did I miss here?

If you have the drop-down, where a single click completes the selection and
fills the cell, where the heck does "case sensitivity" come into the
conversation?

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

If you create a delimited list, by typing the entries in the Data
Validation dialog box, it's case sensitive.
Instead, you can type the list on a worksheet, then name the range that
contains the list. In the data validation dialog box, refer to the list
name, e.g.: =MyList

There are instructions here:

http://www.contextures.com/xlDataVal01.html

 

[Debra Dalgleish]

If a cell contains a data validation dropdown list, you can select from
the list, or type a valid entry in the cell.

If the data validation list is delimited: Yes,No
you can only type Yes or No in the cell.

If the list is a range reference, and the cells contain Yes and No, you
can type YES, NO, yes, no, or any case variation.

 

[Ragdyer]

Yes Debra, I realize that!

BUT ... even my "not overly bright" users wouldn't attempt to key in
anything that's already been done for them.<bg>

 

[Guest]

Hi Dox: I would use a CheckBox - just a thought

"Dox" skrev: