Dropdown lists

  • Thread starter Thread starter stevebicks
  • Start date Start date
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
 
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
 
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
 
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 **
 
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
Click to expand...
 
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
 
Thanks for that Frank, i checked the site out earlier but i missed tha
part, it was 3am though lol

ever grateful

Stev
 
Back
Top