While using VBA, you may have encountered many different errors (or bugs). These VBA errors fall into 3 categories:

1. Compile error
2. Runtime error
3. Logical error.

These VBA errors are discussed in below.

Read More

Have you ever had an Excel worksheet that needed specific input from the user for some calculations? Most applications rely on inputs from users to determine various functions or procedures. Excel has a number of functions that allow you to gather user input for your applications. This article will show you how to use the Excel VBA InputBox function to get user input for your worksheets.

Read More

We are going to learn how to sort data in columns with VBA instead of using Excel’s sorting feature. We are going to random sort the data in columns using VBA.

Read More

In this article, we are going to learn how to refer to a cell in VBA. When using one of the most common task is to refer to a cell or a range of cell and then do something to it like changing the format of the cell or entering a formula in the cell. An example is highlighting the cell A1.

Read More

In this article, we are going to learn how to insert and use a toggle button in an Excel worksheet. A toggle button is used to indicate a state, such as Yes/No or a mode, such as On/Off. The button alternates between an enabled and disabled state when it is clicked. For example, you can use the toggle button to hide and unhide rows, hide and unhide columns, hide and unhide a chart, switch between design mode and edit mode, or as an alternative to the check box. Either way, you can see that toggle buttons are very useful.

Read More

In this Excel lesson, you will learn how to insert Scroll Bar to your worksheet. Also you will find out how useful is to insert it to make your worksheet more interactive and dynamic.

Read More

In this article, we are going to learn how to declare a variable in VBA Excel. First, we are going to learn what a variable is and then some of the types of variable are. Finally, we are going to learn how to initialize and use variables in Excel VBA.

Read More

In this Excel VBA tutorial, you are going to learn how to create and call a VBA function in Excel. Excel provides the user with a large collection of ready-made functions. These functions are usually more than enough to satisfy the average user’s requirements.

If these functions aren’t enough, or if a user is looking for a new function, many more of these functions can be added to Excel by installing the various add-ins that are available.

Most calculations can be achieved with what is provided. However, sometimes you are doing a tedious task, and before long you find yourself wishing that there was a function that did a particular job, and you can’t find anything suitable in the list. That’s when you need a UDF, or a “user-tailored” function.

A UDF (User Defined Function) is simply a function that a user creates for him or herself with VBA. UDFs are often called “Custom Functions”. A UDF can be simple or very complex; depending on the user.

To use a VBA function, you must first create it. Follow these steps to create a VBA function and call it:

Read More

Excel offers a large number of built-in functions that you can use to perform many different tasks easily and quickly. But at least once, you might have felt that the built-in functions provided by Excel are not enough for you to perform some complicated task.

In such cases, you will have to write your own functions, and this is done using VBA. VBA stands for Visual Basic for Applications. Moreover, whenever you have to use a block of code repeatedly, it is advisable to create a function so that you can reuse the code easily.

Read More

In this lesson, you’ll learn how to insert Option Buttons (also known as Radio Buttons) in Excel. Option Buttons allow you to choose one option from a group. Here’s how to use them:

Read More