98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access VBA Training and help » VBA
VBA
Resolved · Low Priority · Version 2003
Hiren has attended:
Excel VBA Intro Intermediate course
VBA
Can you code Vlook ups ?
thanks
H
RE: VBA
Hi Hiren
Thanks for your question
You can indeed code vlookups. They are included in the application object's worksheet functions collection. You type the keyword followed by the function's arguments
For example
application.worksheetfunction.vlookup("A1","C1:H5",3,False)
Hope this is useful
Regards
Stephen
Sun 4 Apr 2010: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create own ribbon tab - Access 2010a. In Access click on the File tab |