Building an application for data entry – Inserting VBA ComboBox (ActiveX Control) The VBA ComboBox is called a drop-down list that we can use in Excel. Please note that this is not the same type of list that we can enter in Excel for data correctness. As in the case […]
vba
35 posts
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 […]
1. VBA tables – information for advanced users I assume that if you are reading this article you have previously read the basic information about VBA tables , which I wrote about in this article: VBA arrays. In the article you are reading you will learn more advanced information about VBA tables. These are functions that you […]
VBA conversion functions – Description. How to change data type in VBA Excel? In this chapter, you will learn all convertion functions in Excel VBA . When writing programs in VBA, you will have often a situation where you will have to change the data type. As you probably know, […]
Building an application for entering data – How to insert VBA TextBox (ActiveX control) VBA textbox has already been introduced to the previous part of VBA course. VBA textbox field is used to enter data and then to process them with VBA code. Inserting a TextBox field into Excel sheet starts with […]
Excel VBA training: Building an application for entering data Let’s do an example that uses all of the known ActiveX controls. Our goal will be to build a short application for entering personal data. The application will be based on the Excel spreadsheet. Its main purpose is to simplify data entry into columns […]
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 under Excel. For the construction of slightly more […]
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 of loops is that For Each we can […]
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 to use VBA For loop to display the “For […]
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 example, finish the instructions earlier, by entering the […]
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 to do some operations many times. In VBA Excel, there […]
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 you enter. Depending on what data you enter at […]
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 functions that source code you write yourselve. You can […]
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. You can also subtract two dates from each […]
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 will be described in other chapter. VBA Character functions can […]
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 value and the number of decimal places to […]
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 activities, manipulate text data and dates. You can […]
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: arithmetic Arithmetic operators serve as the name suggests […]
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, choose the types of data that you really […]
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 variable name that will be interpreted as a variable, and then you can execute any instructions on it. I put an example listed below. 'OfficeInside.Org Sub […]
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 […]
InputBox window – entering data into VBA It’s great, that you have already reached this part of VBA tutorial. After the VBA MsgBox window you will learn how to work with window for entering data into our VB code. Like the MsgBox window, this window has many additional parameters. Let’s […]
VBA MsgBox – data presentation in window You have lerned basics of VBA MsgBox window while writing your first program here: VBA first program. This window is one of many possibilities to present something using VBA code in Excel. It can be use to display messages, the program results etc. Below […]
1. 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 learn in detail the possibilities offered by the VBA in the Excel worksheet. If you are wondering how to write a program that will […]
1. What is macro 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 are based on code, which were written in […]
1. How to write first program in Excel VBA If you already know what macros are and what the VBA is, it’s time to write your first program in VBA. First of all we would like to fill A1 cell in the Excel worksheet with message Welcome to VBA! To […]
1. VisualBasic Editor – Introduction The VisualBasic editor will be the tool that you will use in this course. In order to take full advantage of the VBA option on your computer, you should start with: Unlocking the Developer tab in Excel Enable macro operations in Excel 2. How to […]
Why do we use VBA? You can use the VBA code in Excel for example to: Create useful macros Make own functions, ie. functions that Excel doesn’t have Create Excel add-ons Use programs not related to Excel Automate your work. Imagine, your work is done and you can do more […]
1. VBA VLookUp – How to match rows? Do you want to match Excel records in VBA? VBA in Excel gives you the possibility to use the sheet functions. VBA VLookup is very important spreadsheet function. To use vLookUp function, refer to the worksheet functions using command Application.WorksheetFunction.VLookup. Let’s create two simple tables in Excel […]
1. Search for the last row number in the Excel table using VBA. Often in VBA we need to add another row or data record into the Excel table. To do this, it is usually necessary to find the location of the last non-empty row. To find the last completed record in the […]
1. Log VBA function – Description The Log VBA function returns value of the natural logarithm. Natural logarithm is based on e number ~ 2.72 (Euler’s number). To calculate natural logarithm value, you should use this function. For example, the value of natural logarithm from 1 is 0. 2. VBA Log […]
1. Int VBA function – Description The Int VBA function is used to round numbers that have decimal places to integers. The Int function, in comparision to the Round function, does not require entering additional arguments. The result will always be an integer. An important information is that for negative numbers, the VBA […]
1. Fix VBA function – Description The Fix VBA function is used to round numbers, that have decimal places to integers. The Fix function, in comparision to the Round function, does not require entering additional arguments. The result will always be an integer. Important information is, that for negative numbers, the VBA […]
1. Exp VBA function – Description The Exp VBA function returns an exponential value of a number. To calculate exponential value, you should use this function. For example, exponential value from 1 is the Euler’s number ~ 2.72. 2. VBA Exp function – Syntax 'officeinside.org Exp (Number As Double) As […]
1. Abs VBA function – Description The Abs VBA function returns the absolute value of a number. If you use this function for positive numbers it will return unchanged argument. The function used for negative numbers will return a positive value. If you want to calculate the absolute value in VBA, […]