Writing VBA Code

Learning Objectives

• To analyze how the VBA works
• To discuss how to write VBA codes
• To explain the common mistakes to be avoided while writing VBA codes

Course Description

There are several spreadsheet programs but from all of them, Excel is most widely used. 

People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features. The best part about Excel is, it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence.

Have you ever wanted to learn how to automate Excel so that even the most complex functions can be achieved quickly and simply?

Using a step-by-step approach, this highly popular CPE course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel. Visual Basic for Applications is a computer programming language developed and owned by Microsoft. 

While users cannot directly manipulate the main Excel software through VBA, they can, however, master the art of making macros to optimize their time in Excel. With VBA you can create macros to automate repetitive word- and data-processing functions, and generate custom forms, graphs, and reports. VBA functions within MS Office applications; it is not a stand-alone product

VBA becomes easy, once you learn its coding. 

Writing VBA codes may seem tricky from the outside. But once you get the idea of coding, soon enough you will start generating your VBA databases.

Join this excel CPE webinar to learn how to write codes in VBA.

It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover in this CPE webinar will work similarly in Excel for PC and Mac

Overview

• Writing various lines of code to input value in a dataset

  4 mins
• Usage of Message Box in VBA

  16 mins
• Writing code for inserting a message box

  18 mins
• Declaring various variable types

  26 mins
• Usage of variant variable type in a VBA code

  38 mins
• Using a procedure in VBA code

  43 mins
• Working on user-defined functions in a VBA

  57 mins