当前位置: 动力学知识库 > 问答 > 编程问答 >

excel - based on the selected value in the Activex combobox how to use vlook up

问题描述:

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!

分享给朋友:
您可能感兴趣的文章:
随机阅读: