vba objects
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

VBA Objects

resolvedResolved · Low Priority · Version 2007

replyReply Fri 12 Dec 2008, 15:58Delegate Anthony said...

Anthony has attended:
Excel VBA Intro Intermediate course

VBA Objects

What is an object variable?

For upcoming training course dates see: Pricing & availability

replyReply Mon 5 Jan 2009, 14:45Trainer Stephen said...

RE: VBA Objects

Hi Anthony

Thank you for your question

An object variable is simply usd to access all the properties and methods of the object to which it is assigned.

For example if you defined an object called varSheet as a worksheet and then set it equal to a specific worksheet in your project, then you can use it to reference and change any relevant property

Regards

Stephen

Mon 12 Jan 2009: Automatically marked as resolved.

 


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard