Drop Down Menus

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would appreciate any help anyone can give me on how to prepare my own drop down menus. For example I would like to choose:

Single Room
Double Room
Twin Room
Executive Suite

from a drop down menu instead of typing it in every time.

Many thanks in advance
 
Hi

Select the range, where you want to use drop-down's.
Data.Validation.List with Source '=Single Room,Double Room,Twin
Room,Exclusive Suite'

--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets


Chris Turner said:
I would appreciate any help anyone can give me on how to prepare my own
Click to expand...
drop down menus. For example I would like to choose:
 
Hi Avri,
This is a useful method,
typing in the drop-down values,in the source, rather than having to have a range of values on the worksheet, to list as source.
However, how do I represent a 'blank' ie no-fill choice.
Cheers
Mathew
Hi

Select the range, where you want to use drop-down's.
Data.Validation.List with Source '=Single Room,Double Room,Twin
Room,Exclusive Suite'

--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets


Chris Turner said:
I would appreciate any help anyone can give me on how to prepare my own
Click to expand...
drop down menus. For example I would like to choose:
 
Hi


MathewPBennett said:
Hi Avri,
This is a useful method,
typing in the drop-down values,in the source, rather than having to have a
Click to expand...
range of values on the worksheet, to list as source.
However, how do I represent a 'blank' ie no-fill choice.
Click to expand...

You can't! But you can leave it blank, when it was blank before. Or you can
delete old entry - thus leaving the cell blank (balnk values aren't
restricted unlike others not included into list).

About usefulnes of typing list directly into source field - it's handy when
the list is fixed, and it isn't too long. Otherwise I always prefer named
ranges as source.
 
Back
Top