background preloader

Work

Facebook Twitter

Excel VBA Tutorial - Easy Excel Macros. VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. 1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros.

Excel VBA Tutorial - Easy Excel Macros

In this chapter, learn how to create a simple macro. 2 MsgBox: The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program. 3 Workbook and Worksheet Object: Learn more about the Workbook and Worksheet object in Excel VBA. 4 Range Object: The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA. Excel Experts E-Letter Archives. The Excel Experts E-Letter (or EEE) is a newsletter produced by David Hager.

Excel Experts E-Letter Archives

EEE is filled with useful tips and tricks for Excel. Most of the material in geared towards the more advanced user. Note: The EEE newsletter is no longer distributed via email. Any future issues will appear here. I'm pleased that David has agreed to make the past issues available from The Spreadsheet Page. SpreadsheetZONE - Free Excel Template Repository. KnowExcel.com - Help with Excel - Teach Microsoft Excel.