Embeded ComboBox

[Guest]

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)

 

[Rick Rothstein \(MVP - VB\)]

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