Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embeded ComboBox
If I have an embeded "ComboBox" in a sheet. Is there a way to extract the
information into a function formula, such as: =LOOKUP(ComboBox.1,Sheet3!B4:B18252,MFR_CODES) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embeded ComboBox
If I have an embeded "ComboBox" in a sheet. Is there a way to
extract the information into a function formula, such as: =LOOKUP(ComboBox.1,Sheet3!B4:B18252,MFR_CODES) You should be able to do what you asked using the cell the ComboBox is linked to. If you used a ComboBox from the Forms Toolbar, then you could use a look up function to look up the Index value placed in the linked cell to find the actual selected ComboBox value... if you used an ActiveX ComboBox, then the selected value is placed directly into the linked cell. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parent of the embeded excel | Excel Discussion (Misc queries) | |||
How to print 15 embeded charts on two sheets at once? | Charts and Charting in Excel | |||
Embeded Excel File gridlines? | Excel Discussion (Misc queries) | |||
protect embeded object | Excel Discussion (Misc queries) | |||
protect embeded object | Excel Worksheet Functions |