Excel VBA Programming Course: Lesson 1-Understanding Visual Basic for Application (VBA)

Hello and welcome to Excel VBA Programming Course.

I'm really excited to introduce you to one of the most powerful tools available in the Microsoft Office ecosystem, Visual Basic for Applications.

So what is Visual Basic for Applications?
Visual Basic for Applications Also known by the popular acronym VBA is an object oriented programming language. Now if you're not familiar with programming if you've never written a line of code if the term object oriented is unfamiliar to you that's totally fine.This course is designed for complete beginners. All you need is a little bit of basic excel knowledge.

Programming is the idea of giving a set of instructions to the computer a sequence of steps for the computer to follow in order to execute some kind of task. When it comes to VBA. VBA is used to automate tasks in Microsoft Office applications like Excel, Word, PowerPoint, access, outlook Etc.

VBA consists of snippets of code that we call procedures or macros. Some people also call them subroutines, routines or programs just different names for the same thing. But all of these snippets of code are just sequences of steps.

Imagine that you have a real life scenario where you want to explain to your co-worker how to perform some kind of task in Excel like modifying a daily report. You might call them over and say the first thing I need to do is to highlight all of the headers and make them bold. Then change the fonts to this font. Change the font size to this.Perhaps add a border next at the bottom of the worksheet.

The exact same way that you describe this process to a coworker is the exact same way that we are going to describe it to VBA. We're just going to use a different syntax a different language in order to communicate with the computer but anything that you can do in Excel in the main interface. You can tell VBA to do that with code.

What can VBA help you do in Excel?
Well VBA is really great at repetition.
Vba is excellent for working on multiple workbooks and worksheets
Vba Is excellent for repetitive tasks
You can create personalized functions using VBA
Good at user events and react accordingly
You can create custom user interfaces
Finally although it's not covered in this course, VBA can also be used to communicate between different office applications.

Why learn VBA?
Reduces redundancy dramatically
VBA is an excellent skill to pick up as a general user, employee as well as business owner.
Get a good understanding of computer programming environment
Could be of great help in the Job Market

History of Vba?
VBA is a modern dialect of the Programming language called BASIC which was developped in 60’s
In the early 90’s Microsoft released Visual Basic Programming Language
Visual Basic for Application (VBA) was released in 1994.
VBA and VBA were inspired by basic yet are completely different languages

All right so let's dive into the prerequisites for the course before I dive into the technical requirements. I want to really emphasize the importance of participation and experimentation no matter how many tutorials you watch.There really is no substitute for writing code yourself. You have to be willing to try out different things yourself. You have to be willing to make mistakes. You have to be willing to deal with the frustration of running into a bug and having to google it and reading responses on different social medias and the like no matter how effective a course is no matter how many video tutorials or quizzes or assignments there are. the single best way to learn is to try things out yourself. This is the number One Priority

So I strongly recommend regardless of your excel knowledge or your programming knowledge. Whenever you watch a video in this course, Copy the code alongside it and in your own version of Excel.

Now as far as the technical requirements you do need a working copy of Microsoft Excel. The good news is that VBA is pre-installed with Excel so a working excel copy is more than enough for you. That's it. We're all good to go.

That's all there is to cover in this lesson. I'm really excited to teach you how to use VBA.

Don't forget to subscribe.

#excel10tutorial #learnVba #VbaCourse

Connect us on social media

[ismailjafari]

Dear sir,
Please tell me how can i open multiple time a master sheet by a button. In order to enter data in same sheet multiple time.
Would appreciate your kind feedback.
Thanks.

[archanaaa]

Sir I am beginner to vba. What skills should I knw about vba to get a job?