Excel: The Complete VBA Programing

Learning Objectives

• aTo analyze how to develop macros.
• To discuss the format worksheets.
• To inspect how to create an interactive worksheet.
• To investigate work with multiple worksheets.
• To discuss how to perform calculations.
• To understand the basics of VBA language
• To understand properties window and user forms
• To learn the functions procedures and code modules.
• To understand how to write VBA codes
• To understand the common mistakes to be avoided while writing VBA codes
• To learn the logic of VBA
• To understand the important tools of VBA
• To learn how to use the VBA tools
• To learn the basics of VBA loops
• To understand various VBA loop statements
• To learn different types of VBA loops

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?

Are you facing a repetitive cleanup of fifty tables in Word? 

Do you want a particular document to prompt the user for input when it opens? 

Are you having difficulty figuring out how to get your contacts from Microsoft Outlook into a Microsoft Excel spreadsheet efficiently?

A few of you must have backed off from trying VBA thinking that it involves difficult coding and structuring requirements. Well, here, we will learn how to work with VBA the best way!

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.

Excel VBA is Microsoft’s programming for Excel and all the other Microsoft Office programs, like Word and PowerPoint. The Office suite programs all share a common programming language. 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.

To access the VBA window, press Alt + F11 within any Office program. When done properly, this will open a window with a file structure tree on the top left, properties on the bottom left, a debug pane at the bottom center and bottom right, and the coding section that takes up the majority of the screen in the center and top right. 

This may seem overwhelming at first, but in reality, it’s simpler than it appears and this CPE webinar will help you with that. This CPE course is ideal for those with a good knowledge of MS Excel and would like to add additional functionality, with no programming knowledge. 

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

The real power in programming comes from the options that you have to determine which lines of code to execute, based on one or more conditions that you specify. You can extend those capabilities even further when you can repeat an operation many times. 

Join this excel CPE webinar to learn everything you need to know about 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

• Benefits of using a VBA

  2 mins
• Creating a macro using VBA

  8 mins
• Adding sub-procedures in a VBA editor

  21 mins
• Introduction to various elements of VBA code

  26 mins
• Declaring various variable types in a VBA code

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

  44 mins
• Working on input box and message box in a VBA

  50 mins
• Working on Excel functions in a VBA

  65 mins
• Working on user defined functions in excel

  84 mins
• How to use Do until loop in VBA

  130 mins