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.

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.

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 he

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

Art wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Debra,

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



"Debra Dalgleish" wrote:

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 he

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

Art wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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 !
-----------------------------------------------------------------------------------------------

"Debra Dalgleish" wrote in message
...
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 he

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

Art wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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 wrote:
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?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Debra Dalgleish" wrote in message
...
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 wrote:
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?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

"Dox" skrev:

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.