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!