Monday, August 16, 2010

Understanding EXCEL Window

Excel’s basic unit is the worksheet, every worksheet divided to 256 columns and 65,536 rows. The intersection of rows and columns is called "cell", so each worksheet contains 256 x 65,536 = 16,777,216 cells. Excel uses the A1 cell to refer to columns, rows, and cells:
  • Columns are designated from A to IV.
  • Rows are numbered from 1 to 65536.
*cells A1, A2, Z1234, IV65536 and etc is called the cell address.

But this is not I want to explain here, my main thing is to start using VBA application in Excel.

VBA is stand for Visual Basic for Application. If you are using Excel 2003, you're lucky when VBA is included in normal office package but if you are using Excel 2007 you have to do add/ins from your original installation CD. View here for add/ins procedure.

How to start using VBA?
For shortcut you may press ALT-F11 or follow on below picture to open VBA. Remember this is in Microsoft Excel Windows.
Once you complete the task VBA window will appear.

No comments:

Post a Comment

Please add if your have better information.