Office tutorials

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