VBA in excel

How to Use the Select Case Structure in Excel VBA

One can implement conditional logic in VBA using an IF statement, multiple IF-Elseif statements or one can use the Select Case statement in order to ...

How to use INDEX & MATCH worksheet functions in Excel VBA

You can utilize the built-in Excel Worksheet functions such as the VLOOKUP Function, the CHOOSE Function and the PMT Function in your VBA code and ...

6 Best Excel VBA Programming Books (For Beginners & Advanced Users)

Do you often find yourself, doing repetitive tasks over and over again in Excel and wishing that somehow, someway these tasks could be automated? ...

How to Import Data from a Website to Excel?

It is well known that World Wide Web contains huge useful data. However, we have to import the data into Microsoft Excel before doing any kind of ...

Learn Excel VBA Programming & Macros (Free Tutorial – Step by Step)

This is a complete guide on Excel VBA. If you're a beginner user of Excel VBA, you will get your best start here. If you're using Excel VBA for the ...

Excel VBA Worksheet Related Events and Their Uses

In this article, I will discuss (in detail) the Excel VBA Worksheet Events and their uses. This is a very thorough guide and I have tried to explain ...

What are Excel Events and Their Types

So far in various articles, I have discussed about Events and Event handlers. To give you a fresh start, let's have a look at the Events and Events ...

Excel ActiveX Controls Properties (Checkbox, Combo box, List box, …)

In this article, I am going to give an overview of available ActiveX controls that you can use in your worksheet. After reading this article, you ...

How to Use ActiveX Controls in Excel (Step by Step)

In this article, you will learn how to use ActiveX controls in Excel, step by step. You'll be relieved to hear that adding ActiveX controls in a ...

Excel Form Control vs. ActiveX Control (7 Differences)

In our previous articles, you have been introduced to Excel UserForms. In this chapter, I am going to discuss Excel Form Control Vs Activex Control. ...

InputBox Function in Excel VBA

The InputBox function The InputBox function is useful for obtaining a single input from the user. A simplified version of the function’s syntax ...

How to Create a UserForm: an Overview

This article is part of my series: VBA & Macros in Excel – A Step by Step Complete Guide and Make UserForms in VBA Excel with Total 6 Tutorials. ...

How to Use Excel VBA User Defined Function in Formula

Excel VBA provides two procedures. One is functions also known as the user-defined functions another one is subroutines. In this tutorial, I am going ...

What is an Argument in Excel with Example

Excel has many functions for different operations.  Inside the parenthesis of the functions, we put some inputs for the desired operation that we ...

5 Differences Between Subroutine & Function in Excel VBA

There are lots of similarities between a custom Function/User-Defined Function procedure and the Sub-procedure/Subroutine. However, Function ...

ExcelDemy
Logo