VBA Excel

Excel/VBA Range Select Method

In the selected cells, you may perform various tasks e.g. setting the font name, making it bold/italic, etc., setting the background color of the selection and others.

4 Examples of Excel/VBA Find with What & After Arguments

The Find function has various arguments (required/optional), our focus for this tutorial is using “What” and “After” arguments.

How to Remove Single/Multiple Rows by Delete method in VBA

Excel rows can be deleted by using Delete method in VBA. You may specify WorkSheets.Rows.Delete method to remove one or more rows

Excel/VBA Range [11 Examples]

VBA has a Range object that can be used to select the range of cells in an Excel sheet. You may use Range object to get the cell’s value.

5 Examples to use Excel/VBA InputBox

InputBox:is a function in VBA i.e. used to display a textbox field/prompt to the user to take input. It Returns a string as user clicks the “Ok” button or press enter

Set the Border Color of Excel Cells by VBA Color/ColorIndex Properties

You may use Borders.ColorIndex property to set the border color from available 56 color palette

How to hide Excel Sheet Columns in VBA

Hiding columns in VBA By using Worksheet’s Columns property, you may hide one or more…

VBA Rows Property – Access Single/Multiple by Range

To select a row in an Excel sheet, you may use the Range object Rows property. You may select one or more rows by using the Rows property

5 Examples of How to get Array Length/Size in VBA

For one dimensional array, you may get the array length (size) by using UBound function.

How to Create and Access Arrays in Excel VBA

How to create arrays in VBA by using different ways. Accessing array elements by index. One-dimensional and two definitional arrays (using Excel Sheet)

VBA If..Not (Logical Operator): Explained with 2 Examples

Basically, Not operator negates the given condition. It is used to reverse the result of a condition or expression.

Excel/VBA Interior/Background Color by ColorIndex/Color

The interior (background) color of the cells in the Excel sheet can be set by using the VBA ColorIndex property.

4 Examples as Solution to VBA Continue Statement

As we know, VBA has “Exit For”, “Exit Do” to come out of the loop entirely – which is achieved by the break statement (normally in other programming languages).

VBA break is Available? How to Exit For Loop?

In programming languages, there is normally a break statement is available to exit a loop (For, While, Do While) while it is still not completed. There is no break statement in VBA.