Getting Started with VBA Programming

Home/Excel VBA/Getting Started with VBA Programming

Welcome to VBA programming tutorials, Getting Started with VBA Programming session we will see overall objective of this course and brief introduction of the topic required to learn VBA programming. You will feel more confident and why we are learning a particular topic and what are the things we can do by understanding each topic.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

Getting Started with VBA Programming – Understanding the Concepts

Following is the brief introduction about the concept which are required to learn for VBA programming. Please have a look and try to understand overall objective of and purpose of each concept.
» Understanding VBA Object Model

Most of the computer languages are Object Based or Object Oriented Programming languages. Excel is Object Based Program and Deal with Objects, its Properties and Methods. To write the VBA code we need to understand the different Objects available in Excel VBA, so that we will refer those Objects while coding or automate a particular task.

For example, if you want to enter some data in a range, you need to refer the Range objects, and we required to refer Sheets Object if you want to activate a specific Worksheet. We will see the most frequently used Excel VBA Objects in this session.

» Working with Excel Objects (Workbook, Sheets, Range and Cell)

We use Workbook, Sheets, Range and Cell Objects in almost every program, we will see the different examples and uses of these Objects in this session.

» Variables and Data Types

Variables play important role in any programming language. We can store some data using variables and use in our programming. Variables are allocated by the computer memory to hold data, we can define the size and name of the variables. We will see more about variables in this session.

» Operators and Operands

There are different operators in VBA help us to compare and assign the values. we will discuss more about operator with examples in this session.

» Conditional Statements

Conditional statements are very useful in programming, it helps to compare and control the program, and helps loop through and iterate the statements based on certain condition..

» Sub Procedures

These are the programming blocks where will write our code to perform required tasks, there are different options related this, we will discuss sub procedure with examples in this session.

» Functions

Functions are another type programming blocks to to perform certain task on input and get the output. These are same like procedures, but there is a difference in use of the functions. We will discuss all about functions in this session.

» Built-in Functions

There are many built-in functions available in VBA, we will see most frequently used functions in this session.

» Worksheet Form Controls

We will discuss about Form Controls available in Worksheet and the uses of these controls and how to code it using VBA in session.

» Worksheet ActiveX Controls

These are more powerfull than Form controls, we access the most of the properties of these controls. We will discuss more about ActiveX Controls and the uses of these controls and how to code it using VBA in this session.

» Error Handling

There are different types of the errors possible while automating, we will see how to handle the errors in this session.

» Learn VBA Programming with Examples – 15 VBA codes to understand VBA Programming

Learning anything with examples makes easy, these 15 examples will help you to understand and to be come more confident with the VBA programming.

By |June 2nd, 2013|Excel VBA|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment

Related pages

vba open filewhat is a hlookupvba worksheet rangevlookup left to rightexcel macro option buttonif iserrormacro excel enablefor each vba excelgenpact interview questions for freshersexcel vba worksheetfunctionexcel vba lookupuseful excel templatesexcel logical operatorsselect case vba excelvlookup excel example 2010removing duplicate cells in excelexcel templates dashboardhide excel columnshow to learn vlookup in excel 2010spreadsheet control vbaoffset command excelsql ddl statementsjoining cells in excelhow to hyperlink excelhow to unhide a column in excel 2007vba code to open excel filewhat is ddl dml and dcl in sqllookup command excelremove duplicate row in excelcolumn width excel vbaexcel vba untilmacros programming in excelexcel vba array valuevba code to unprotect excel workbookprotecting worksheets in excelgenerate xml from excelvba singleexcel vlookup vbaproject dashboard templates excelcreate dashboards in excelexcel short cutdatabase ddl dmlsas programming tutorial pdfinsert checkbox in excel 2007excel 2013 pivot tablevlookup function exampleproject portfolio management excel templatehow to use the match function in exceliserror formula in excelvba access tutorial pdfactivecell.columnexcel vba columnwidthadodb connection closevba backcolorinsert radio button in excelmeeting minutes template excelvba excel delete columnshow to use vlookup 2010creating checkboxes in excelfso deletefilehow to record a macro in excelwhat is isna in excelunshare excel spreadsheethow to delete a named range in excel 2010rca format in wordvba secondsmicrosoft excel vlookup examplesexcel estimating spreadsheethow to use pivot tables excel 2010excel vba multiple ifinterview worksheetprotected workbook forgot interview questions and answers pdfms excel vlookup formulaexcel activecellhow to create vlookup in excel 2007excel vba range functionuseful vb scripts for windows 7