Tag Archives: VBA

How to add a control multiple times in Excel VBA Forms

September 10, 2009 – 12:40 pm | By Gatt | Posted in Software | Also tagged , , | Comments (0)

You can drag a control to place it on the form. If you want to place again, you need to drag it again. Read More »

How to work on multiple controls simultaneously in Excel VBA Forms

August 7, 2009 – 12:42 pm | By Gatt | Posted in Software | Also tagged , | Comments (0)

You can work on the multiple controls at the same time and change properties. Keep holding Ctrl key and select multiple controls (such as labels). Read More »

Key Data Types in VBA

June 28, 2009 – 12:24 pm | By Gatt | Posted in Software | Also tagged , , | Comments (0)

A data type communicates to program what kind of variable is needed in operation.

Here is a quick list of data types. Read More »

Important Windows Control used to design Form in Excel VBA

June 20, 2009 – 12:39 pm | By Gatt | Posted in Software | Also tagged , | Comments (0)

Form is the graphical container where other controls can be added to make user input logical and meaningful in Excel.

Here are the key controls Read More »

Using Select Case Statement in VBA

February 14, 2009 – 12:28 pm | By Gatt | Posted in Software | Also tagged , , | Comments (0)

If you have large number of conditions to verify, Select Case statement provides a way to check these conditions easily and in readable manner. Read More »

Different types of If statement with examples in VBA

February 5, 2009 – 12:27 pm | By Gatt | Posted in Software | Also tagged , , | Comments (0)

Here is a list of If Statement for Visual Basic for Application. Read More »

Application Object and Important Properties in VBA for Excel

January 25, 2009 – 12:34 pm | By Gatt | Posted in Software | Also tagged , | Comments (0)

Application Object is the highest object in Excel, followed by Workbook, followed by Worksheet and followed by Column, Row and cell. You can select object by going from highest to lowest in Excel. Read More »

Types of Loops in VBA

January 21, 2009 – 12:30 pm | By Gatt | Posted in Software | Also tagged , , | Comments (0)

Loops are used to repeat actions. Read More »

Introduction to Visual Basic for Application (VBA)

December 16, 2008 – 12:22 pm | By Gatt | Posted in Software | Also tagged , | Comments (0)
What is VBA

Microsoft Office documents (Excel, Word etc) are shipped with extensive functionality which is more than enough for most users. But there may be a need for enhancement to these applications or automate certain tasks that standard versions of these software are not equipped with. For this purpose, Microsoft applications include a programming environment to add new functions to standard application. Read More »