Vlookup with Text Number: Exmp: A1

[AsifShah]

Hello Dear Friends
Please Help On This Metter.
Below Vlookup formola working fine when i using Number ( 1 2 3 4 5 ...) but when i use Text or Text With Number Exmp: (A1) its showing error and not working.
Please Friends provide a Vlookup code that work with Text & Number Example: A1. bcz iam making a little software for my office work. Ploting Saling my Plot number is start with text number( A1, A2, B3 )

With Me
.TextBox4 = Application.WorksheetFunction.VLookup(CLng(Me.TextBox3), Sheet1.Range("PlotList"), 3, 0)
.TextBox5 = Application.WorksheetFunction.VLookup(CLng(Me.TextBox3), Sheet1.Range("PlotList"), 5, 0)
.TextBox6 = Application.WorksheetFunction.VLookup(CLng(Me.TextBox3), Sheet1.Range("PlotList"), 5, 0)
End With

Thanks

 

[AsifShah]

Any one help please...