Skip to content

General VBA

Peter M Taylor edited this page Jul 17, 2016 · 5 revisions

What is covered for this category?

Under the Dryfus model, the topic classifies our general understanding of Visual Basic for Applications and their components of an internal editor that resides within our Microsoft Product.

To begin this journey, we start using the [basic] approach, we ask ourselves the question of what's vba and why there is a need for an editor called the VBA IDE.

To [advanced] further, we approach from what we know about VBA into something that our skills with macros by starting automating repeative steps and this includes using some short cut keys to cut our time using the editor.

To be [compentent] we look closely at our macro and find they use objects; we learn more of what objects mean and how we can use them including fixing a bug as this occurs.

To be [proficient], having grasp how what objects, let us put together some modules and functions that VBA uses to pass information in some way.

To be an [expert], we can be confident to write up some code within VBA editor using objects with modules and functions.

[expert]:

Clone this wiki locally