Last Updated on January 11, 2023 by token Introduction to ActiveX controls It’s great that you have already reached this part of the VBA Tutorial. VBA ActiveX controls are controls used to visualize our applications in Excel. ActiveX controls available in the Developer tab are used primarily to build simple applications running […]
Yearly Archives: 2018
42 posts
Last Updated on January 11, 2023 by token What is the For Each Next loop in VBA? In this article you will learn what the For Each Next loop is and how to use it in Excel VBA. The For Each Next Loop is an extension of the VBA For loop. The difference between the two types […]
Last Updated on January 11, 2023 by token VBA For Next loop – basic informations The VBA For Next Loop is another loop that we will learn. In the simplest words, the loop allows us to enter in advance the number of repetitions of instructions to be done. For example, let’s try […]
Last Updated on January 11, 2023 by token The diagram of Do While Loop The While…Wend loop, which you learned in the previous chapter is the simplest loop in the Excel VBA. The loop that gives you more options is Do Loop. It gives you more possibilities. You can, for […]
Last Updated on January 11, 2023 by token While Wend loop – introduction The VBA While Wend loop is the simplest in construction loop available in VBA. If your code need to be short, not complicated and have a simple structure, it is recommended to use this loop instead of the […]
Last Updated on January 11, 2023 by token Introduction to the loops in Excel VBA Loops are the most powerfull elements in programming languages. Using them, you can automate activities, speed up your programs, do things that you couldn’t do in the Excel datasheet. The loop, as its name suggests, is used […]
Last Updated on January 11, 2023 by token SELECT CASE instruction – introduction Another instruction next to IF THEN ELSE used in the decision making process by your programs is the SELECT CASE VBA statement. The instruction checks entered value with the defined conditions. On this basis, one scenario is chosen in your decision-making process. After selecting the […]
Last Updated on January 11, 2023 by token VBA IF THEN ELSE – What is the conditional statement? In the simplest sense, VBA IF is the equivalent of the Excel IF(), but function used in the VBA code. Imagine that you want your program to make decisions based on the data […]
Last Updated on January 11, 2023 by token Worksheet functions – How to use the Excel function in VBA Have you ever wondered how you can use the Excel function in VBA? Worksheet functions come with help. As you know, the Excel spreadsheet offers a number of useful functions. The resource of functions […]
Last Updated on January 11, 2023 by token Creating VBA functions defined by user Both Excel and VBA offer you a number of useful functions. But what if you would like to create a VBA function that you will use in Excel? VBA offers you possibility of creating your own functions. These are […]
Last Updated on January 11, 2023 by token Description of date and time functions. VBA date functions, as the name suggests, are used to manipulate the values related to dates and time. On their basis, you can catch any parameter such as day, month, year, etc. from the given date. […]
Last Updated on February 8, 2023 by token VBA character functions in Excel The Excel VBA offers us a number of useful character functions. We can’t compare them to the number of functions in an Excel spreadsheet, and these are not the same functions. The use of the sheet functions in VBA code […]
Last Updated on January 11, 2023 by token Description of math functions in Excel VBA Below I present the names and descriptions of all standard math functions in Excel VBA. As you can see, functions like VBA RND don’t need arguments. Functions like VBA ROUND require 2 arguments – the […]
Last Updated on January 11, 2023 by token Introduction to functions in Excel VBA You have already come to the chapter about VBA functions – Congratulations !!! In VBA we have a large number of useful functions. Using them our programs work in the right way. With their use, you will do mathematical […]
Last Updated on January 11, 2023 by token Types of operators in Excel VBA In our scripts we will use both arithmetic expressions and logical expressions. For this purpose, we will be able to use operators in Excel VBA, we can put them into 3 groups: arithmetic logical comparison VBA operators: […]
Last Updated on January 11, 2023 by token Introduction to data types in Excel VBA Why is it so important to assign a variable to the correct data type? Your program and its variables use the resources of your computer. If you want to ensure that your program works quickly, […]