Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Vlookup from Combo Box | Excel Discussion (Misc queries) | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
dynamic combo boxes | Excel Worksheet Functions |