Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA - vlookups

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

VBA - vlookups

Resolved · Medium Priority · Version 2007

Reply Tue 31 Mar 2009, 16:39Delegate Varuni said...

Varuni has attended:
Excel VBA Intro Intermediate course

VBA - vlookups

Can you use vlookups within VBA - at the moment i dont use VBA, just use combinations of vlookup etc in excel to get what i want.

For upcoming training course dates see: Pricing & availability

Reply Thu 9 Apr 2009, 10:28Trainer Simon said...

RE: VBA - vlookups

Hi Varuni,

Thank you for your question.

The Vlookup worksheet function is available under the WorksheetFunction object in VBA.

You can use most built-in worksheet functions in a macro by calling the function as a method of the Application object or the WorksheetFunction object. So if you are trying to create a Vlookup then type:

worksheetfunction.vlookup(then the arguments)

I hope this answers your question.

Regards

Simon

Reply Wed 15 Apr 2009, 09:34Trainer Simon said...

RE: VBA - vlookups

Hi Varuni,

Thank you for your question. Your question about using Vlookups in VBA.

I replied to you early April with the following text:
---------------------------------------------------------------------
Hi Varuni,

Thank you for your question.

The Vlookup worksheet function is available under the WorksheetFunction object in VBA.

You can use most built-in worksheet functions in a macro by calling the function as a method of the Application object or the WorksheetFunction object. So if you are trying to create a Vlookup then type:

worksheetfunction.vlookup(then the arguments)

I hope this answers your question.

Regards

Simon
-----------------------------------------------------------------------

Can I confirm whether this response has answered your question?

Regards

Simon

Tue 21 Apr 2009: Automatically marked as resolved.

Excel articles

· Data Validation In Excel
· How to Create Better Excel Spreadsheets: Part Two
· Some Interesting Finds In Excel 2007/2010 Using Find And Select
· Should I Use Data Bars, Colour Scales Or Icon Sets In Excel?
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series

Please browse our web site to find out more about
excel training onsite and other Microsoft training courses.

Excel tip:

Closing all your workbooks Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open.

View all Excel hints and tips