VBA for Excel 2007 tutorial |
||||||||||||||
What is VBA ?In this VBA for Excel 2007 tutorial, you will learn common VBA concepts such as variable and data type, operators, conditional statements, loops, sub-procedure and function, arrays, etc. In addition to tutorial points, you will find a lot of VBA example code and programs (more than 100 examples and programs). Where can you write the VBA code in Excel 2007? Simply you can write your VBA code by using Visual Basic Editor of Microsoft Excel 2007. To open Visual Basic Editor, after opening Microsoft Excel 2007, you can press Alt with F11 or go to Developer tab of the ribbon menu then click Visual Basic. Then you will see the VBA Editor as shown below. If you don't see Developer tab, you may display it by going to Excel 2007 options then tick "Show Developer tab in the Ribbon".
|
| |||||||||||||
|
||||||||||||||