Skip to content
Excel Unlocked

Let's Unlock the Power of Excel for You

  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us
Excel Unlocked
  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us

VBA and Macro

Data Types of Variables in VBA

In the previous blog, we learned about the usage and declaration of variables in VBA Programming. Today we will cover different data types of the… Read Article
infographics variables in vba

Variables in VBA – Declare, Initialize, Examples

Variables are one of the basic building blocks of any programming language. Today we will learn about different variables in VBA, naming conventions for a… Read Article
infographics static variables in vba

When to Use Static Variables in VBA?

Static Variables in VBA are particular kinds of variables that are used in different situations. The usage of a Static Variable in VBA is irreplaceable.… Read Article
RUN A MACRO WHEN WORKBOOK IS OPENED infographics

How to Automatically Run a Macro when Workbook is Opened?

In today’s article, we are going to learn about how to run a set of instructions via a macro when a workbook is opened. Running… Read Article
infographics VBA MODULE - TYPES, INSERT, REMOVE

What is VBA Module? Types, Insert, Remove

Today, we will learn about modules in VBA. We are going to know about different types of modules and when to use them. We would… Read Article
infographics user defined function in vba

User Defined Functions in VBA – Define, Call, Example

In the previous blog, we implemented the usage of Sub Procedures. Today we are going to learn about User Defined functions in VBA. This is… Read Article
infographics sub procedures in vba

Complete Tutorial – Sub Procedure in VBA

Sub Procedure is one of the essential fundamentals to start learning VBA. Today, we are going to learn from scratch about what Sub Procedures are,… Read Article
copy and paste a range of cells using VBA infographics

How to Copy and Paste Cells using VBA in Excel

In the previous article, we learned how to select a cell or a range of cells using VBA. Now we are going to learn how… Read Article
infographics select cells and ranges using vba in excel

Select Cells and Ranges using VBA in Excel

We need to select cells and ranges using VBA to perform many functions on the excel spreadsheet. VBA provides an effective way to do this.… Read Article
infographics where to put my vba code

Where to Put VBA code?

We are now going to learn how to copy and paste a VBA code into your excel workbook as follows.… Read Article
infographics edit a macro rename shortcut key or copy a macro

Edit Macro – Rename, Shortcut key, Copy

In the previous blogs, we learned about recording a macro and writing a macro using the VBA editor. Editing a Macro implies renaming a macro,… Read Article
infographics macro using vba editor

Write a Macro using VBA Editor – Command Button

Today, we will learn to write the VBA code of a macro using the VBA editor. However, we can record a macro without having the… Read Article
Older posts
Newer posts
← Previous Page1 … Page3 Page4 Page5 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Comments

  • wout on How to Insert Picture or Image in Excel Comment
  • ALAMIN ABUBAKAR ZARMA on TRUE and FALSE Function in Excel
  • Matthias Lüpke on How to Send Email From Excel Automatically

Archives

Categories

  • Charts (69)
  • Functions (280)
  • Tips and Tricks (73)
  • VBA and Macro (52)

Mission

ExcelUnlocked is dedicated to unlocking the power of Excel for professionals, students and all others who use Excel in their day to day activity.

Excel Unlocked
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ExcelUnlocked.com 2023