问题描述:

based on the selected value in the Activex combobox how to use vlook up in the particular sheet and show that data in the another sheet.

网友答案:

use the LinkedCell property and type the address in there. If you want that value in the other spreadsheet you can use a simple worksheet formula = to get that done.

Add a script in VBA for the combobox when it changes like this:

Private Sub ComboBox1_Change()
    Range("YOURCELL").Value2 = ComboBox1.Value
End Sub

Then cell "YOURCELL" will contain the value of the combobox whenever its value changes. If you reference that "YOURCELL" cell in your vlookup you are there!

相关阅读:
Top