VLOOKUP in VBA - Text Boxes

[karl_009]

Hi,

Am trying to use a VLOOKUP in VBA on a form, I am entering data in one field so data will be displayed in another field.

They are both text boxes.

Here is the code;

Private Sub phoneport_Change()

Me.phoneport.Value = Application.WorksheetFunction.VLookup(Me.phoneext.Value, Sheets("LookupData").Range("A2:B23"), 2, False)

End Sub

Thanks for any help

Karl