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