Excel VBA Archives - ANALYSISTABS - Innovating Awesome Tools for Data Analysis!

Excel VBA is the macro programming language available in the Excel and other MS office tools. It helps to automate the regular tasks, create the dashboards and build the tools to perform certain tasks.

VBA ActiveSheet – Excel Active Sheet Object
VBA ActiveSheet – Excel Active Sheet Object

Excel VBA

VBA ActiveSheet – Excel Active Sheet Object

VBA ActiveSheet Object helps to refer the currently activated sheet in the active workbook. We can get all properties and methods of the ActiveSheet using VBA. Let us see the useful of the examples on Excel VBA ActiveSheet Object. What is Active Sheet in Excel VBA? Set a Worksheet as Active

By PNRao|August 6th, 2019|Excel VBA|0 Comments

Excel VBA ColorIndex
Excel VBA ColorIndex

Excel VBA

Excel VBA ColorIndex

VBA ColorIndex Property of Excel VBA is very useful to set the fill colors, border colors and font colors. Excel VBA ColorIndex returns index values from 1 to 56, -4105 and -4142. You can set the default colors using VBA enumeration number -4105 ( or xlColorIndexAutomatic). We can set VBA colorIndex -4142 (or xlColorIndexNone) enumeration

By PNRao|July 6th, 2019|Excel VBA|0 Comments

Excel VBA Copy Range to Another Sheet with Formatting
Excel VBA Copy Range to Another Sheet with Formatting

Excel VBA

Excel VBA Copy Range to Another Sheet with Formatting

Very often we need to copy the Excel Range to another sheet with formatting. We can use VBA to automate this task. Excel VBA Copy Range to Another Sheet with Formatting macro is explained to know how to copy a range to another worksheet using VBA. How to Copy Range to Another Sheet with Formatting

By PNRao|July 5th, 2019|Excel VBA|1 Comment

Show or Hide|Unload a userform
Show or Hide|Unload a userform

Excel VBA, VBA

Show or Hide|Unload a userform

Show or hide means to display or hide a Userform. We use Show and Hide methods to display or hide. Unload will be used when completes the task.

By PNRao|October 2nd, 2015|Excel VBA, VBA|1 Comment

Column Number to Column Name
Column Number to Column Name

Excel VBA

Column Number to Column Name

Column Number to Column Name is nothing but converting column number to Excel alphabetic character column name. Most of the time while automating many tasks using Excel VBA, it may be required.

By PNRao|June 28th, 2015|Excel VBA|4 Comments

Column Name to Column Number
Column Name to Column Number

Excel VBA

Column Name to Column Number

Column Name to Column Number is nothing but converting Excel alphabetic character column name to column number. Most of the time while automating many tasks it may be required. Please find the following details about conversion of column name to column number. You can also say column string to column number. Or get alphabetic character to column number using Excel VBA.

By Valli|June 10th, 2015|Excel VBA|0 Comments

Remove CheckBox on Worksheet or UserForm in Excel
Remove CheckBox on Worksheet or UserForm in Excel

Excel VBA

Remove CheckBox on Worksheet or UserForm in Excel

We can remove or delete checkbox on the worksheet or userform using ‘Go To Special’ or ‘Select Objects’ or by turning on Design Mode in Developer tab. when we don’t want to place checkbox control on the worksheet or userform we removes from there. Please find the more details and screenshots for clear understanding about remove checkbox control in the following chapter.

By Valli|April 15th, 2015|Excel VBA|7 Comments

Add CheckBox on Worksheet or UserForm in Excel
Add CheckBox on Worksheet or UserForm in Excel

Excel VBA

Add CheckBox on Worksheet or UserForm in Excel

Add CheckBox on Worksheet or UserForm is using checkbox control and is used to specify or indicate binary choice. In this section we will see how to add single checkbox or multiple checkboxes on the worksheet or userform. Please find more details about add checkbox control in the following chapter.

By Valli|April 12th, 2015|Excel VBA|2 Comments

Remove Alpha Special characters from Range using Excel VBA

Examples using Procedures and Function to Remove Alpha Special characters from Range using Excel VBA to get only numeric data from specific range.

By PNRao|September 29th, 2013|Excel VBA|1 Comment

Excel Chart VBA Examples and Tutorials

Here are the top most Excel Chart VBA Examples and Tutorials, show you how to deal with chart axis, chart titles, background colors,chart data source, chart types, series and many other chart objects.

By PNRao|September 8th, 2013|Excel VBA|30 Comments

Introduction to Collections in Excel VBA

Collection is an object contains group of objects having similar characteristics (with same properties and methods). For example,if you want to loop through all worksheets in a workbook, you can refer worksheets collection of the workbook and do whatever you want to do with that particular worksheet.

In this topic:

Introduction to Collections?

Collections in Excel VBA

Examples Macro File On Collections

By PNRao|August 25th, 2013|Excel VBA|1 Comment

VBA ComboBox Excel Macros Examples Codes Adding Clearing Items

ComboBox in Excel VBA-Adding new Items,Adding new Items to another ComboBox based on selection of first ComboBox ,Clearing,Example Tutorials and Codes

By Valli|August 25th, 2013|Excel VBA|36 Comments

ListBox in Excel VBA – Adding, Clearing, Multiple Selection Examples
ListBox in Excel VBA – Adding, Clearing, Multiple Selection Examples

Excel VBA

ListBox in Excel VBA – Adding, Clearing, Multiple Selection Examples

ListBox VBA Excel Example Macros Codes for Adding new Items,Moving all Items, selected Items from ListBox to another ListBox,clearing,Multi selection. VBA ListBox in Excel is one of finest control in the Excel. You can show the list of items in the listbox and user can select any item and do different operations. In this tutorial,

By Valli|August 24th, 2013|Excel VBA|21 Comments

ADO in Excel VBA – Connecting to database using SQL

ADO Stands for ActiveX Data Objects, is Microsoft’s Client-Server technology to access the data between Client and Server. ADO can’t access the data source directly, it will take help of OLE DB Provider to communicate with the data source. Most of the times OLE DB providers are specific to a particular Data Source Type. However, we have an OLE DB provider for ODBC, it is a general purpose provider with help of this ADO can access any Data source which can understand ODBC.

In this topic:

What is ADO?

What is Database?

What is SQL?

Practical Learning: Using ADO and SQL with VBA

Example File

By PNRao|August 18th, 2013|Excel VBA|134 Comments

Events in Excel VBA

Event programming is the most useful tool which helps to monitor specific user actions within Excel. For example, if the user Opening a Workbook, Selects a Worksheet, enters data into a Cell, or saves a Workbook, these actions are all Excel Events.

In this topic:

What Are Events?

What Are The Different Types of Events?

Practical Learning: Workbook_Open Event

Example File: Workbook Events, Worksheet Events and Form Events

By PNRao|August 11th, 2013|Excel VBA|6 Comments

Procedures in Excel VBA

In this Section:

What is a Sub Procedure?

Calling a Sub Procedure

Procedures and Access Levels

Examples on Sub Procedures - With and With Out Parameters

Example File

By PNRao|August 4th, 2013|Excel VBA|2 Comments

Conditional Statements in Excel VBA – If Else, Case, For, Do While, Do Until, Nested Ifs

Conditional statements in Excel VBA helps to control the programming. Learn IF,If Else, Nested If, Case, For, Do While, Do Until statements with examples.

By PNRao|July 28th, 2013|Excel VBA|6 Comments

Operators and Operands in Excel VBA

Operators and Operands in Excel VBA very useful concept to programming the tasks. Our free tutorials take you through the concep