Introduction to VBA
VBA stands for Visual Basic Application. . It is an event driven Programming language by Microsoft now a days it is predominantly used with Microsoft applications such as MS –Excel , MS-Word, MS-Access. VBA Application MS-Excel Provides loads on inbuilt functions.MS-Excel Provides only basic inbuilt functions which may not be sufficient to perform complex calculations but by using VBA we can create our own functions and perform our desirable tasks How to Access VBA Editor In excel windows Press “ALT +F11” to open VBA editor .. Step 1: At first open Excel sheet Step 2: Follow Above Tricks and open VBA Editor will be open which looks like this . Some Important VBA Terminologies Modules : Modules is the area where code is written. In above figure there is no any modules. How to insert Module ??? To insert modules in VBA right click on Microsoft Office Objects and then a win...

Comments
Post a Comment