Office tutorials

Date and time functions in Excel VBA

Description of date and time functions. The VBA date functions as per the name indicate are used to manipulate values ​​related to dates and time. On their basis, we can receive any parameter from the given date, such as day, month, year, etc. We can also subtract two dates from each other. If we want to enter […]

VBA mathematical functions

Description of mathematical functions in Excel VBA Below are the names and descriptions of all standard math functions in Excel VBA. As you can see functions such as RND () do not require arguments. Functions such as ROUND () require 2 arguments – the value and the number of decimal places to which we round our value. Numbers with decimal places in […]

Functions in VBA Excel

Introduction to functions in Excel VBA You have already come to the chapter about functions – Congratulations, keep it up !!! In VBA we have a number of useful functions. It is through them that our programs will work in the right way. With their help, we will perform mathematical activities, manipulate text data and dates. We reference the […]

Operators in VBA Excel

Types of operators in Excel VBA In our scripts we will use both arithmetic expressions and use logical expressions. For this purpose, we will be able to use operators in Excel VBA, we can divide them into 3 groups: arithmetic logic comparison. VBA operators: arithmetic Arithmetic operators serve as the name suggests the implementation of actions math. When […]

VBA data types in Excel

Introduction to data types Why is it so important to assign a variable to the correct data type? Our program and its variables use the resources of our computer. If we want to ensure that our program works quickly and efficiently, we choose the types of data that we really want to use. For example, we do not write dates […]

Constant values in VBA Excel programming

What are constant values in VBA? In the previous chapter of the training you learned what are the VBA variables appearing in our VBA code. The difference between variables and constants of VBA is such that the values ​​assigned to constants will not change during the launch of our program. If we want our code to be fully compliant […]

Excel VBA Variables

Introduction to VBA variables. In VBA, as in other programming languages, we work with variables. The VBA language does not require declaring variables. You can, for example enter a variable name that will be interpreted as a variable, and then execute any instructions on it. I put an example listed below.

The result of the example operation is […]

VBA MsgBox window in Excel

VBA MsgBox – data presentation in window You need to know the VBA MsgBox window while writing your VBA first program. The window of this function is one of many possibilities of data presentation using VBA code in Excel. It can be used to display any message, the result of your program etc. Below is an […]