Office tutorials

Monthly Archive: June 2018

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

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 use on the boards, how […]

Read More

VBA Error handling – How to use it? In this article you will learn what VBA error handling is and how to use it efficiently. In VBA, as in any other program writing errors appear. They may result, among others from the incorrect syntax or logic of the program. Errors that may occur in VBA can be divided into: […]

Read More

VBA conversion functions – Description. How do you change the data type in VBA Excel? In this chapter you will learn all the conversion functions in Excel VBA . When writing programs in VBA, you will often encounter a situation in which you will have to change the format of the data. The direct cause here can be the discrepancy […]

Read More

What are tables in VBA Excel – VBA Arrays In this chapter of the VBA course you will learn what VBA tables are and how to use them in data analysis. VBA tables are containersfor storing data of the same type in an organized manner. We can refer to each element of an array using its indexed address. Arrays can also be compared to […]

Read More

How do you write an Excel add-in in VBA? Creating a simple add-on in VBA Excel is primarily about writing a good VBA macro code. In this chapter you will learn how to install such a macro as an Excel add-in. The add-on will consist of two macros: Macro 1 – opening the file saving window and […]

Read More

How do you insert the ComboBox combo box into the UserForm form? The combo box is already known to us. We got to know them while creating the application for entering data . Due to the fact that the field inserted in the UserForm form is programmed in a different place, we will create an example in which we […]

Read More

Insert MultiPage tabs into the UserForm form MultiPage Bookmarks are pages of our application, between which the user will be able to pass. On each page you will see other elements and content of the application. To insert bookmarks into our UserForm form, we should choose the MultiPage control from the ToolBox. Our application should have two pages. By […]

Read More

How to build an application in Excel VBA using the UserForm form In the last part of the course we will deal with the creation of a short application using the form. As in the case of the previous application, we should write down the basic requirements based on which our application will operate:: Our goal […]

Read More

What is VBA UserForm  The UserForm form is a form that works under Excel that allows us to create visually developed applications. You can add more types of controls to the UserForm form than to the data sheet. From the controls of the UserForm form, we can distinguish primarily: Label label TextBox text field ComboBox combo box […]

Read More