Tag Archives: Syntax

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 »