Skip to content
Excel Unlocked

Let's Unlock the Power of Excel for You

  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us
Excel Unlocked
  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us
infographics msgbox function in vba

Message Box in VBA – MsgBox Function

In this tutorial, we would learn about a very important functionality provided by VBA. We will learn about Message Box and its Syntax along with… Read Article
infographics objects, properties and methods in vba

Objects, Properties and Methods – VBA

Although VBA is not purely Object Oriented Programming language, it has the use of Objects. In this article, we are going to learn about Objects,… Read Article
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
Older posts
Newer posts
← Previous Page1 … Page4 Page5 Page6 … Page42 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Comments

  • Nilesh Patel on Excel DATEDIF Function – Find Difference Between Dates
  • daniel on Excel XNPV Function – NPV With Irregular Cash Flows
  • wout on How to Insert Picture or Image in Excel Comment

Archives

Categories

  • Charts (69)
  • Functions (281)
  • Tips and Tricks (73)
  • VBA and Macro (73)
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ExcelUnlocked.com 2025