Help Help Help Help!!!!!

[stapleton2308]

Please can someone help - im fairly new to excel, and what i want to do
is know how to use a combo box. I've gone onto the control toolbox
toolbar, and seen the drop down bar, but where do i put the data i want
to be in it???? I've used the validation one in the past, but i dont
want to use this again. I just want a standard drop down bar which i
can move whereever. Also, i would like to use the autocomplete option
as well. Please help!!!

 

[Big Chris]

Not sure how the detail pasted in below will look to you, but it's the
way I always put it together. Easy when you know....and a great little
tool.

And I have no idea about AutoComplete I'm afraid - but hope this gets
you going in the meantime.

Have a great day!

Chris

-------------------------------------------------------------

A B C D E
1 Cell Link input range
2 2 1 Apple
3 2 Orange
4 3 Pear
5 4 Cherry

=VLOOKUP(A2,D25,2,FALSE) This is the value you want to return from
the Combo Box choice.

 

[stapleton2308]

i cant seem to make that work, do i have to use VBA for it, if so what
do i need to do as i aint gotta clue!!!

 

[Bob Phillips]

Setup a list of values,a nd set the ListFillRange property to those cells,
say M1:M10.

To set that property, go to design mode (click the blue-green triangle on
the control toolbox toolbar), and then double-click the combo. This takes
you to the VB IDE, make sure properties window is open (Ctrl-G), and set
that property. Exit design mode and go.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"stapleton2308" <[email protected]>
wrote in message
news:[email protected]...

 

[stapleton2308]

thanks bob - yeah it worked, also, once ive for example typed the first
few letters it will then display the match, i then want to be able to
press the TAB button so it moves to the next cell, is that possible?
Also, if i was to type letters/words that didn't appear in the drop
down, can i get it to say something like 'not in list'??