how to use vlookup

  • Thread starter tkraju via OfficeKB.com
  • Start date
T

tkraju via OfficeKB.com

how to use vlookup function in Vba.
I need Vlookup(userform.textbox1.value,w/sheet1.range("A1"A25",2,false)
 
M

muddan madhu

Application.WorksheetFunction.VLookup(TextBox1.Text, Range("A1:B10"),
2, 0)
 
J

Jacob Skaria

All worksheet functions can be accessed from VBA using

Application.WorksheetFunction.<function>

If this post helps click Yes
 
T

tkraju via OfficeKB.com

Actually Vlookup finds first occurance of a value in vertical looup.Ineed
code for last occurance.
 
Top