Abdul Alim: a little bit learning, let's go
Excel, VBA and Power BI tutorials
Abdul Alim: a little bit learning, let's go
Excel, VBA and Power BI tutorials
VBA is stands for Visual Basic for Applications. It works with the Microsoft office applications like – Excel, Word, PowerPoint etc.
Here we will learn VBA with MS Excel. We can automate are daily work, which we do in excel.
We can write our code in Visual Basic Editor. To open a Visual Basic Editor, we need to enable Developer tab first.
Go to the File>>Options>>Customize Ribbon>>Check the Developer option.
Enable Developer Tab in Excel
You also can watch below given video to learn how enable the developer tab.
Visual Basic Editor is available in left side.
Visual basic Editor option
Click on Visual Basic or Press Alt+F11 short cut key to open a Visual Basic Editor.
Visual Basic Editor Window looks like below image.
Visual Basic Editor
Now we will learn in next chapters how to write code in Visual Basic Window