Help Help Help Help!!!!!

Help Help Help Help!!!!!

Post by stapleton2 » Sat, 28 Jan 2006 18:53:01



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!!!


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/
 
 
 

Help Help Help Help!!!!!

Post by Big Chri » Sat, 28 Jan 2006 19:15:54


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,D2:D5,2,FALSE) This is the value you want to return from
the Combo Box choice.


--
Big Chris

Very experienced with excel in general and formulae but just started to
learn VBA....and it's hard!!
------------------------------------------------------------------------
Big Chris's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/

 
 
 

Help Help Help Help!!!!!

Post by stapleton2 » Sat, 28 Jan 2006 19:29:15


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!!!


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/
 
 
 

Help Help Help Help!!!!!

Post by Bob Philli » Sat, 28 Jan 2006 20:57:39

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" < XXXX@XXXXX.COM >


http://www.yqcomputer.com/
 
 
 

Help Help Help Help!!!!!

Post by stapleton2 » Sat, 28 Jan 2006 21:44:59


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'??


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/
 
 
 

Help Help Help Help!!!!!

Post by stapleton2 » Thu, 16 Feb 2006 23:14:42


Hi,

If i have data which in one cell which looks like below:

ABC 0001
DDS 0002
HHH 0003
EEI 0004

(each of these has once space between the letters and numbers)

How can i combine it, so the cells now looks like:

ABC0001
DDS0002
HHH0003
EEI0004

Help would be much appreciated

Thanks


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/
 
 
 

Help Help Help Help!!!!!

Post by S2luamFsaX » Thu, 16 Feb 2006 23:31:15

Hey, you can select the column, then go to Edit>Replace. Then on the Replace
tab place a space in the "Find what:" area then select Replace ALL. This will
remove all of the spaces.

Hope this helps
--
Jeffrey L. Lippard, A+ certified, CHDP certified
 
 
 

Help Help Help Help!!!!!

Post by Qm9iIFVtbG » Thu, 16 Feb 2006 23:32:30

in a parallel column (assuming your data starts in A1):
=SUBSTITUTE(A1," ","")
and fill down. Then copy this new range, select A1, Edit/Paste Special,
click Values & OK.
Lastly, clear the formulas justg created.
HTH
Bob Umlas
Excel MVP
 
 
 

Help Help Help Help!!!!!

Post by Qm9iIFVtbG » Thu, 16 Feb 2006 23:39:27

My bad. Jeffrey L. Lippard's solution is easier! Duh!