VBA objects – The ultimate guide

This is a comprehensive article about creating and using objects in Excel VBA.

If you are serious about learning VBA then it is important to understand VBA Objects. Using objects is not that difficult. In fact, they make your life much easier.

In this post, you will see how VBA makes brilliant use of objects. How objects such as Collections, Workbooks and Worksheets save you much complexity, time and effort.

Topics include:

• What is a VBA object?
• Object components.
• Creating a VBA object.
• Assigning VBA objects.
• VBA objects in memory.
• Why Set is useful.