VBA Combo Box in Excel SpreadSheet Inserting VBA Combo Box (ActiveX Control) The VBA ComboBox is a drop-down list that you can use in Excel. Remember, that this is not the same type of list that you can enter in Excel for data correctness. As in the case of a […]
vba
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 […]
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 […]