vlookup from a combo box?
 

Is it possible to have a vlookup command that's looking up what a combo box
displays? How do I do this?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

Is the combo box from the Forms toobar, or the Controls toolbox? In either
case, you can link it to a cell, then have the VLOOKUP operate on that cell.
The two work differently, though.

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"MA via OfficeKB.com" wrote in message
...
Is it possible to have a vlookup command that's looking up what a combo
box
displays? How do I do this?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

thank you - it worked. Now how do I get the arrow on the right side of the
dropdown menu to disappear after I have selected something?


Earl Kiosterud wrote:
Is the combo box from the Forms toobar, or the Controls toolbox? In either
case, you can link it to a cell, then have the VLOOKUP operate on that cell.
The two work differently, though.

Is it possible to have a vlookup command that's looking up what a combo
box
displays? How do I do this?


--
Message posted via http://www.officekb.com

MA,

If you're referring to the triangle that points downward, I don't think you
can get rid of it. It's supposed to be there. It indicates to the user
that it can be expanded. Without things to click, users go berserk. You
could change the DropButtonStyle property (if this is a combo box from the
Controls toolbox -- you never did say). But the button will still be there.
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"MA via OfficeKB.com" wrote in message
...
thank you - it worked. Now how do I get the arrow on the right side of the
dropdown menu to disappear after I have selected something?


Earl Kiosterud wrote:
Is the combo box from the Forms toobar, or the Controls toolbox? In
either
case, you can link it to a cell, then have the VLOOKUP operate on that
cell.
The two work differently, though.

Is it possible to have a vlookup command that's looking up what a combo
box
displays? How do I do this?


--
Message posted via http://www.officekb.com