vlookup from a combo box?

[MA via OfficeKB.com]

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

 

[Earl Kiosterud]

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.

 

[MA via OfficeKB.com]

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]

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.