M
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?
displays? How do I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
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.
case, you can link it to a cell, then have the VLOOKUP operate on that cell.
The two work differently, though.
M
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?
dropdown menu to disappear after I have selected something?
E
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.
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.