Userform ComboBox 'Vlookup'

[johnpants]

Hello, I have a Userform with a populated combobox (combobox4), what I want to to is if someone selects something from the combobox, it checks a range and enters a specific cell into a textbox (textbox12).

At the minute the range I want it to check is HH10:HI85, the details for the combobox are in HI column, and the details I want it to enter into the textbox are in HH.

Is this possible? Any help would be much appreciated as my boss is on my back to get this last bit done today..

Thanks,

john.

 

[BrianB]

I have assigned this to a button although the Private Sub ComboBox4_Change() event would do just as well :-

Private Sub CommandButton1_Click()
    TextBox14.Value = _
        Application.WorksheetFunction.VLookup _
        (ComboBox4.Value, Range("hh10:hi85"), 2, False)
End Sub

 

[johnpants]

Thank you very much Brian, that's what I am looking for, but it is falling over and bringing up error: 'Unable to get the vlookup property of the worksheet function class'

I'm gonna fiddle with it and see if I can figure it out, any ideas why this would happen? Could it be because the worksheet is protected at all?

Thanks again.