Easily learn Visual Basic (VBA) for Microsoft Excel.

We cannot connect excel

“We can’t connect to” in Excel

"We can't connect to" pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are...

Getting VBA setup in Excel

Setting up VBA does not require any special software installation. The VBA development software is included with each package of the Microsoft Office suite...

VBA Formatting Cells

Learn to format cells using VBA.

VBA ColorIndex

Colors Colors could be very important and useful in excel application. There are two ways in which you can...

What is a Macro?

Macro is just the name given to the codes written in VBA. So our codes, henceforth, will be referred to as Macro.

Writing Your First Macro

Learning to write your first macro in excel is very exciting. In this tutorial we will write and run our first simple...

What is VBA in Excel?

VBA VBA, which stands for Visual Basic for Application, is a programming language developed to work with Microsoft’s...

Selections, Formatting Cells and Color (Color Index)

Majorly, all the programming or tasks you do in Excel requires you using Cells, or focuses on Cells, therefore, you need to...

VBA Select Method

Selection is a method in Excel VBA that performs an action. You use the Select method to select a single cell or...

Latest Tutorials