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
infographics search item in collection vba

Search Item in Collection – VBA

In the previous article, we learned about the Collections in VBA. Today, we would implement the searching by checking if a particular item exists in… Read Article
infographics collections in vba

Collections in VBA – Create, Add, Remove Items

In this blog, we would learn about Collections in VBA. It has a lot of applications in the VBA programming language. We kept the article… Read Article
passing parameters by value in vba

Passing Arguments by Value – VBA

In the previous part, we learn about passing procedure arguments by reference. Today we would learn another approach to passing parameters to a procedure. This… Read Article
infographics private and public procedures in vba

Private and Public Procedures in VBA

We have practiced the Sub Procedures and Functions in VBA. Today, we will learn about the scope of procedures. The Private and Public Procedures in… Read Article
infographics passing parameters by reference in vba

Passing Procedure Arguments by Reference – VBA

We already know about Sub Procedures and Functions in VBA programming. The Sub Procedure is used to execute a block of code without returning any… Read Article
infographics constants in vba

Constants in VBA – Declaration, Types. Scope

In the previous article, we learned about the variables in the VBA Programming language. Variables contain values that can be changed during the program execution.… Read Article
infographics string data type in vba in excel

Strings in VBA – Fixed and Variable Length

In the previous article, we learned the use of variants. Today we would learn about another interesting topic. Strings are one of the frequently used… Read Article
infographics variant data type in vba

Variant Data Type in VBA Excel

Previously. we learned about various numerical and nonnumerical data types in the VBA programming language. Today, we would learn about another particular data type which… Read Article

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
Older posts
Newer posts
← Previous Page1 Page2 Page3 … Page39 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 (277)
  • Tips and Tricks (73)
  • Uncategorized (3)
  • VBA and Macro (36)

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