Hello I am trying to get vba to vlookup a value from a combobox and return a value from the data sheet. My code so far is:

Private Sub TextBox1_Change()
Me.TextBox1.Value = Application.WorksheetFunction.VLookup(Me.ComboBox2.Value, "a2:ao10000", 41, 1, True)
End Sub

I am trying to look at the value in combobox2 and return the relevant data from that row in the data sheet in textbox1. A2:AO10000 is my data sheet range, I am trying to return the data in textbox1 from column a.

Any ideas?

Thanks

Zak