Excel programming

Read more about the article Your First VBA Programme | Put Your Knowledge into Practice
Your first VBA project in Excel — Calculate the square of a number with InputBox

Your First VBA Programme | Put Your Knowledge into Practice

In this tutorial from Iran VBA's free tutorial series, we will create our first programme in the Excel environment and practise fundamental VBA concepts hands-on. If you are new to…

Continue ReadingYour First VBA Programme | Put Your Knowledge into Practice
Read more about the article Variable Scope in VBA | How to Access Variables across Different Parts of a Project
Educational cover image for the post “Variable Scope in VBA” — from IranVBA tutorials

Variable Scope in VBA | How to Access Variables across Different Parts of a Project

In the previous tutorial, we learnt how to declare variables. In this part of the free VBA training series, we’ll explore the concept of Variable Scope and how it defines…

Continue ReadingVariable Scope in VBA | How to Access Variables across Different Parts of a Project
Read more about the article Data Types in VBA (with Range Table and Naming Prefixes)
Table of VBA data types with value ranges, memory usage, and variable name prefixes

Data Types in VBA (with Range Table and Naming Prefixes)

VBA supports various data types, and choosing the right one has a direct impact on execution speed, memory usage, and preventing type conversion errors.In this article, we’ll review all numeric…

Continue ReadingData Types in VBA (with Range Table and Naming Prefixes)