VBA

In VBA, how to include double quotes in your strings? The answer is using Chr() function with 34 code. See examples in this tutorial.

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.

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

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

InputBox:is a function in VBA which used to display a textbox field/prompt to the user to take input. Learn how to use in this guide.

VBA CStr function is used to convert a value to a string. Learn using this function at our tutorial @ jquery-az.com with examples.

You may use VBA Borders.ColorIndex property to set the border color from available 56 color palette for the Excel cells. Learn how…

By using Worksheet’s Columns property, you may hide one or more columns in VBA. We will take you step by step in this tutorial.

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.

To select a row in an Excel sheet, you may use the Range object Rows property. Understand how in this tutorial.

For one dimensional array, you may get the array length (size) by using UBound function. Learn how to get array length in VBA.

VBA Not operator negates the given condition. It is used to reverse the result of a condition or expression. Learn in this tutorial.

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

Discover the arrays in VBA. Store multiple values in a single variable, iterate through them, and create flexible and powerful macros.

Learn how to omit a single iteration in a loop in VBA. The tutorial shows you four examples to achieve this task.