Office tutorials

Latest Articles

Excel VBA Shell – How to control programs from Excel

1. CMD Shell in VBA Excel – what it is and how to use it In this article you will […]

VBA Arrays – Extended information

1. VBA tables – information for advanced users I assume that if you are reading this article you have previously […]

Error handling in Excel VBA

VBA Error handling – How to use it? In this article you will learn what VBA error handling is and […]

Excel VBA conversion functions – How to convert variable

VBA conversion functions – Description. How do you change the data type in VBA Excel? In this chapter you will learn […]

Arrays in VBA Excel – Basics

What are tables in VBA Excel – VBA Arrays In this chapter of the VBA course you will learn what VBA […]

VBA Add-ons – Creating Add-ons in Excel

How do you write an Excel add-in in VBA? Creating a simple add-on in VBA Excel is primarily about writing […]

UserForm – ComboBox in Excel VBA

How do you insert the ComboBox combo box into the UserForm form? The combo box is already known to us. We […]

UserForm form – MultiPage form in Excel VBA

Insert MultiPage tabs into the UserForm form MultiPage Bookmarks are pages of our application, between which the user will be […]

UserForm – Building an application in Excel VBA

How to build an application in Excel VBA using the UserForm form In the last part of the course we […]

Introduction to UserForm in Excel VBA

What is VBA UserForm  The UserForm form is a form that works under Excel that allows us to create visually […]