ExcelDemy.com Blog

Objects and collections, Properties, Methods, and Variables in Excel VBA 0

Objects and collections, Properties, Methods, and Variables in Excel VBA

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. Objects and collections VBA is an object-oriented programming language. As name shows, object oriented language works...

How VBA works in Excel 1

How VBA works in Excel

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. VBA is the most complex feature in Excel. If you have background in object oriented programming...

Excel VBA Coding Tips 0

Excel VBA Coding Tips

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. When you write your VBA code, remember to write it in such a way that any...

Writing VBA code in Excel: Entering and Editing code 0

Writing VBA code in Excel: Entering and Editing code

In our preceding articles, we have demonstrated the easiest way to create simple macros using macro recorder. To make complex macros, you have to write program using VBA. To save time in developing your...

Copy your macros to a Personal Macro Workbook 1

Copy your macros to a Personal Macro Workbook

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. Most macros are created for use in a specific workbook, but it is possible to use...

Macro recording in Excel: Absolute vs Relative 0

Macro recording in Excel: Absolute vs Relative

When you’re recording your own macros, you must know the concept of relative versus absolute recording modes. In our this article an example of recording a macro in Excel, we have shown that because...

How to add a macro to your Quick Access toolbar in Excel 2

How to add a macro to your Quick Access toolbar in Excel

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. You can also assign a macro to a button on your Quick Access toolbar: Right-click the...

How to assign and change a shortcut key to a macro in Excel 1

How to assign and change a shortcut key to a macro in Excel

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. Assigning a macro to a shortcut key When you start recording a macro, the Record Macro...

Assigning a macro to a button in Excel 0

Assigning a macro to a button in Excel

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. After you have recorded and tested a macro, you may want to assign your macro to...

Recording Macro in Excel – Learn with an Example 0

Recording Macro in Excel – Learn with an Example

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. In this example, we shall demonstrate how to record a time-stamp macro that inserts the current...

How to create VBA Macros in Excel using Macro Recorder 1

How to create VBA Macros in Excel using Macro Recorder

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. This is a long article on how to create VBA macros in Excel. So, study this...

Two types of VBA Macros: VBA Sub procedures & VBA functions 0

Two types of VBA Macros: VBA Sub procedures & VBA functions

Before we digging in how to create macros, we need to understand the types of VBA macros. This article is part of my series: Excel VBA & Macros – A Step by Step Complete...

How to save workbooks that contain Macros 1

How to save workbooks that contain Macros

If your workbook contains one or more VBA Macros, you must save the file with an XLSM extension. This article is part of my series: Excel VBA & Macros – A Step by Step...

About Macro Security in Excel 0

About Macro Security in Excel

Macros can cause serious damage to your computer. It can erase files or install malware. Microsoft has added macro-security features to help prevent your working devices (computer or smart phones) from macro-related problems. This...

How to show the Developer Tab on the Ribbon 0

How to show the Developer Tab on the Ribbon

When you’re planning to work with VBA macros, you’ve to make sure that the Developer tab is present on the Excel Ribbon. The Developer tab does not appear by default. Developer tab contains useful...