I have problem. i have some number at worksheet. And i
want lookup that's number to my macro with vba. This
is like function at worksheet ( Vlookup)
this code
Private Sub TextBox1_AfterUpdate()
Dim myrange As Range
Dim Mycol As Range
Set myrange = Worksheets("sheet1").Range("a1:b10")
Set Mycol = myrange.Columns([1], [2])
TextBox2.Value =
Application.WorksheetFunction.VLookup(TextBox1,
myrange, Mycol, [False])
End Sub