1. When this code is used with the sample table, cell A4 will be selected. How to Select the Blank Cell at Bottom of a Column of Contiguous Data. To select the cell below a range of contiguous cells, use the following example: ActiveSheet.Range('a1').End(xlDown).Offset(1,0).Select When this code is used with the sample table, cell A5 will be selected.
2. Wondering where the VBA code goes in your Excel workbook? Excel has a VBA backend called the VB editor. You need to copy and paste the code in the VB Editor module code window. Here are the steps to do this: Go to the Developer tab. Click on Visual Basic option. This will open the VB editor in the backend.

1. Microsoft Visual Basic For Excel
2. Microsoft Excel Visual Basic Reference
3. Visual Basic For Beginners Excel

VBA Conditional Statements

Search the list below for free Excel VBA code examples complete with explanations. Below you will find a list of basic macro examples for common Excel automation tasks. Copy and Paste a Row from One Sheet to Another. This super simple macro will copy a row from one sheet to another. How to write a visual basic program. Visual Basic programs for beginners with examples. How to print a string in visual basic. Below are some examples of visual basic programs. In this tutorial, Will see some basic string operation like how to print string and char in visual basic. Check the visual basic program for mathematical operations.

The main Excel VBA Conditional Statements are the If ... Then statement and the Select Case statement. Both of these evaluate one or more conditions and, depending on the result, execute specific sections of code.

The two Conditional Statement types are discussed individually below.

The Visual Basic If ... Then Statement

The If ... Then statement tests a condition and if it evaluates to True, executes a specific section of code. If the condition evaluates to False, a different section of code is executed.

The syntax of the If ... Then statement is:

In the above If statement, you can add as many ElseIf conditions as you require. Alternatively, the ElseIf and the Else parts of the conditional statement can be omitted if desired.

In the example below, an If ... Then statement is used to color the current active cell, depending on the value of the cell contents.

Note that, in the above example, the If statement stops once it has satisfied a condition. Therefore, if the ActiveCell value is less than 5, the first condition is satisfied and so the cell is colored green. The If ... Then statement is then exited, without testing any further conditions.

Microsoft Visual Basic For Excel

For further information on the VBA If ... Then statement, see the Microsoft Developer Network website.

The Visual Basic Select Case Statement

The Select Case statement is similar to the If ... Then statement, in that it tests an expression, and executes different sections of code, depending on the value of the expression.

The syntax of the Select Case statement is:

In the above code, the Case Else part of the conditional statement is optional.

In the following example, the Select Case statement is used to color the current active cell, depending on the value of the cell contents:

The above example illustrates different ways of defining the different Cases in the Select Case statement. These are:

Microsoft Excel Visual Basic Reference

Note that as soon as one case in the Select Case statement is matched, and the corresponding code executed, the whole Select Case statement is exited. Therefore, the code will never enter more than one of the listed cases.

For further information on the VBA Select Case statement, see the Microsoft Developer Network website.

Visual Basic For Beginners Excel