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 using VBA code. If you are trying to do any action in Windows using Excel, the most of these actions are used […]
Excel VBA Tutorial
VBA Error handling – How to use it? In this article you will learn what VBA error handling is and how to use it correctly. In VBA, as in any other programming languages errors appear. They may be caused by incorrect syntax or logic of the program. Errors that may occur in VBA […]
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, […]
VBA Arrays – basic informations What are arrays in VBA Excel – VBA Arrays In this chapter of the VBA course you will learn what VBA arrays are and how to use them in data analysis. VBA arrays are blocks for storing data of the same type in an organized order. You can refer to each element […]
How to write an Excel add-in using VBA? Creating a simple add-in in Excel VBA is all about writing a good VBA code. In this article you will learn how to do an Excel add-in. The add-in will do the following action: Opens the file saving window and inserts the […]
Insert Multi Page tabs into the UserForm VBA MultiPage Contol are pages of your application, between which the user will be able to jump. On each page you will see other elements and content of the application. To insert pages into our UserForm, you should choose the MultiPage control from the ToolBox. […]