Dropdown lists

S

stevebicks

Hi all :)

how do i create dropdown lists, ie so i can select a name from a lis
instead of typing it

hope you understand what i mean :confused:

thanks for any help

Stev
 
F

Frank Kabel

Hi Steve
you can use Data validation for this. Try the following:
- Select the cells you want a listbox for
- Goto 'Data - Validation'. Choose 'List' and select a range with your
stored names for the listbox

For more information on data validation have a look at
http://www.contextures.com/xlDataVal01.html

Frank
 
S

stevebicks

Thanks a lot for the help, that's what i've been looking for except on
problem, how can i make it so that if the name is not in the list th
user can type it in, the validation method will not allow this

thanks again

Stev
 
P

Paul B

Steve, on the data validation error alert tab try unchecking show error
alert after invalid data is entered

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
R

Ragdyer

FWIW
If you wish to continue to use the error alert, and still allow user entry,
all that is necessary is to have a *blank* cell anywhere within the list,
usually at the end, so that the drop-down list will still have the
appearance of a complete list.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Roger Govier said:
Hi Steve

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlDataVal01.html
for a good explanation
 
S

stevebicks

Is it possible to have the reference list located on another sheet t
which it will be used as when i try this it tells me i can't

Stev
 
S

stevebicks

Thanks for that Frank, i checked the site out earlier but i missed tha
part, it was 3am though lol

ever grateful

Stev
 
Top