Embeded ComboBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
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)
Click to expand...

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
 
Back
Top