how to use vlookup
 

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

--
Message posted via http://www.officekb.com

how to use vlookup
 

Application.WorksheetFunction.VLookup(TextBox1.Tex t, Range("A1:B10"),
2, 0)


On Apr 3, 6:55*am, "tkraju via OfficeKB.com" <u16627@uwe wrote:
how to use vlookup function in Vba.
I need *Vlookup(userform.textbox1.value,w/sheet1.range("A1"A25",2,false)

--
Message posted viahttp://www.officekb.com

how to use vlookup
 

Would you be able to post your code...

If this post helps click Yes
---------------
Jacob Skaria


"tkraju via OfficeKB.com" wrote:

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

--
Message posted via http://www.officekb.com

how to use vlookup
 

All worksheet functions can be accessed from VBA using

Application.WorksheetFunction.<function

If this post helps click Yes
---------------
Jacob Skaria


"tkraju via OfficeKB.com" wrote:

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

--
Message posted via http://www.officekb.com

how to use vlookup
 

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

muddan madhu wrote:
Application.WorksheetFunction.VLookup(TextBox1.Te xt, Range("A1:B10"),
2, 0)

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

--
Message posted viahttp://www.officekb.com

--
Message posted via http://www.officekb.com