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 )
Thanks
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 )
VBA Code:
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