Basic Excel VBA Skills to Learn

 

 

 

 

 

 

 

Greetings! This is a brief article to encourage you to learn 4 basic Excel VBA skills.

Each of these skills is discussed in detail in my e-book VBA for Beginners. Below I have put links to more information on these subjects. But I thought you might like to look at six videos  that are not referenced on my website to date.

These videos will help you to understand these four basic Excel VBA skills.

I hope you enjoy watching them.

Best wishes     

Here are the 4 basic Excel VBA skills you should practice.

Skill number 1

1.Variables – Link to the excerpt in VBA for Beginners

A variable is a storage container that holds changing information. It is information stored in temporary memory on your computer. Perhaps you could think of it as a container that holds information that can be used over and over without adding the information each time. A variable is the access to the information.

Video 1: Click the image to watch the video here

Variable in VBA

 

Skill number 2

2. Message Boxes – Link to the excerpt in VBA for Beginners

Our applications should not only hold out their hand to greet the user but should also communicate with them where necessary to ensure that the right decisions are made.
Yes we will be empowering the user with / The right options / Effective decision making / Clear communication.

Video 2: Click the image to watch the video here

VBA Message box

 

Skill number 3

3.Input Boxes – Link to the excerpt in VBA for Beginners

We can let the end users of our applications interact with the data flow with Input Boxes. They are quick, effective and easy to construct and modify. Putting this function into your box of tricks will add greater flexibility to your work

Video 3: Click the image to watch the video here

VBA input box

 

Skill number 4

4. Loops – Link to the excerpt in VBA for Beginners

We are often confronted with the arduous task of working with large data sets and ranges of various sizes and types. Loops work their way through data sets performing repeated tasks for us. Skilfully using loops can save you heaps of time, effort and worry. You can literally find a needle in a haystack.