Office tutorials

1. CMD Shell in VBA Excel – what it is and how to use it In this article you will learn how to control other Windows programs from Microsoft Excel. If you are trying to perform any action in Windows using Excel, all of these actions are used by the Windows Command Shell, so called. command line . The […]

Read More

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 […]

Read More

VBA character functions in Excel The Excel VBA offers us a number of useful character functions. We can not compare them to the number of functions in an Excel spreadsheet, and most importantly, these are not the same functions. The use of the sheet functions in our VBA code will be described in a separate chapter . Character functions like mathematical functions can be […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

Formatting cells and fonts in VBA – introduction Cells as well as other elements of the Excel spreadsheet can be formatted from the VBA code level. The formatting itself can be done in 2 ways. The first way is to set each format using a separate code block. You can also use the With clause to format cells and fonts, which […]

Read More

How to use VBA in Excel worksheet It’s great that you’ve already reached this part of the VBA Excel training. In this chapter we will discuss in detail the possibilities offered by the VBA in the Excel worksheet. If you are wondering how to write a program that will do certain actions for you in […]

Read More

1. What are macros in Excel In this part of VBA course you will learn how to record and run macros under Excel program. As you already know Macros in Excel are programs which are running under Excel. Each of those programs has its own code, which were written in VB language. We use Excel […]

Read More