VB combo box with vlookup

[arkusM]

Hello I have the following code:

Private Sub Vendor_Combo_AfterUpdate()
    Pricing_TB = Application.WorksheetFunction.VLookup(Vendor_Combo, Range("Del_ID"), 5, 0)
End Sub

I am trying to populate a TB in a user form with the value selected in the combo box. but it is failing as soon as I click on the Vendor_combo box and I am not sure why, as it is set to do the vlookup after update.
Ideas?

 

[arkusM]

Have you tried the lookup on the worksheet?


However when I select it in VBA and hit F1 I get taken to a general help page regarding using worksheet functions in code.

It has a link which lists all the available functions.

And in that list there are links to the Excel help topic for all those functions.

That gives me a page cannot be displayed!!

The vlookup works in the worksheet no problem.

 

[arkusM]

Re: VB combo box with vlookup ~~~~ SOLVED ~~~~

Private Sub Vendor_Combo_AfterUpdate()
Pricing_TB = Application.WorksheetFunction.VLookup(Vendor_Combo.text, Range("Del_ID"), 5, 0)
End Sub

Needed to add .text to the Vendor_Combo

clued in here: http://www.mrexcel.com/forum/showthread.php?t=12737