Office tutorials

Monthly Archive: April 2018

1. What are macros 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 has its own code, which were written in VB language. We use Excel […]

Read More

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 do this, open the VisualBasic […]

Read More

1. VisualBasic Editor – Introduction The VisualBasic editor will be the basic 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 2. How to enable Developer tab in Excel? The […]

Read More