1. What is macro 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 are based on code, which were written in […]
excel vba online course
4 posts
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 […]
VisualBasic Editor – Introduction The VisualBasic editor will be the 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 in Excel How to enable Developer […]
Excel VBA Tutorial – What is Excel VBA? VBA Online Course Why do we use VBA? You can use the VBA code in Excel for example to: Create useful macros Make own functions, ie. functions that Excel doesn’t have Create Excel add-ons Use programs not related to Excel Automate your […]