PRESENTATION VBA 4 MS EXCEL

g COMPUTER LANGUAGE AND PROGRAMMING ENVIRONMENT

Microsoft Excel is a spreadsheet application that provides simple to advanced means of creating and managing any type of list. To even make it more powerful and production oriented, MS Excel, like all members of the Microsoft Office family, ships with a computer language and a programming environment.


g MICROSOFT VISUAL BASIC IS A PROGRAMMING ENVIRONMENT

Microsoft Visual Basic for Applications (VBA) is a computer language based on Microsoft Visual Basic. It allows you to write code that can automatically perform actions on a workbook, its worksheets, their columns, their rows, and/or their cells. To write the necessary code, Microsoft Excel also ships with a programming environment called Microsoft Visual Basic that provides all the regular features you need to automate actions on a worksheet.


g OPEN MICROSOFT VISUAL BASIC PROGRAMMING ENVIRONMENT

Before writing VBA code, you must first open Microsoft Excel. To write code, you must open Microsoft Visual Basic. To do that, on the main menu, you can click Tools -> Macro-> Visual Basic Editor. This would open the Microsoft Visual Basic programming environment