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

VBA Objects

ResolvedVersion 2007

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

Anthony has attended:
Excel VBA Intro Intermediate course

VBA Objects

What is an object variable?

Mon 5 Jan 2009, 14:45 Trainer 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.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

VBA Objects

VBA Objects

RE: VBA Objects

Excel articles

Excel tip:

Add Text to Displayed Numbers in Excel 2010