Excel Macros (VBA)
VBA is the programming language used within Excel to develop macros
It stands for Visual Basic for Applications
Complete the special exercises for beginners on this website
Excel macros and programming
Excel 1997 to 2007 included
This website and the downloadable tutorial on Excel Macros are divided in three sections:
Section 1: Excel Macros Programming: Lessons 1 to 10
This section is about recording, writing, modifying and testing macros in the Visual Basic Editor. You will also learn about security and discover "events" (an event is what starts the macro).
Section 2: Excel VBA Vocabulary: Lessons 11 to 23
Developing a macro is communicating with Excel and to do so you need to use a language called Visual Basic for Applications (VBA). In section 2 you will learn all the VBA vocabulary that is essential to work with business data (accounting, sales, production and others).
Section 3: Forms and Controls in VBA for Excel: Lessons 24 to 33
The userform is a small or large dialog window that you create and allows the user to submit values that will be used by your macros. To these userforms you will add controls (command buttons, text boxes, list boxes and others) and program them.
Up to the 2007 version you do not need to install anything
to be able to develop and use macros in Excel.
For users of Excel 2007 and newer versions:
Installing the Visual Basic Editor in Excel from your Office CD
- Lesson 1: Visual Basic Editor in Excel (VBE)
- Lesson 2: Project Window in the Visual Basic Editor
- Lesson 3: Properties Window in The Visual Basic Editor
- Lesson 4: Code Window in the Visual Basic Editor
- Lesson 5: Building Macros in Excel
- Lesson 6: Testing Macros in Excel
- Lesson 7: Macro Recorder in Excel
- Lesson 8: Modifying Macros in Excel
- Lesson 9: Events in VBA for Excel
- Lesson 10: Security and Protection In VBA for Excel
- Lesson 11: Coding Tips
- Lesson 12: Working with Errors
- Lesson 13: Working with the Application
- Lesson 14: Working with Workbooks
- Lesson 15: Working with Worksheets
- Lesson 16: Range and Cells
- Lesson 17: Message Boxes in VBA for Excel
- Lesson 18: Excel VBA Vocabulary to Filter and Sort Data
- Lesson 19: Working with Variables
- Lesson 20: Working with Statements
- Lesson 21: Working with Functions
- Lesson 22: Working with SQL and External Data
- Lesson 23: Working with other programs in VBA for Excel
- Lesson 24: Userforms in VBA for Excel
- Lesson 25: Userform Properties and VBA Code
- Lesson 26: Labels in VBA for Excel
- Lesson 27: Text Boxes in VBA for Excel
- Lesson 28: Command Button in VBA for Excel
- Lesson 29: Combo Boxes in VBA for Excel
- Lesson 30: List Boxes in VBA for Excel
- Lesson 31: Check Boxes, Frames and Option Buttons
- Lesson 32: Spin Buttons
- Lesson 33: Image Controls
|
|
Excel has not changed much since the 1970's but the computer on your desk has changed dramatically. It is hundreds of times faster and more powerful than 10 years ago. It is also connected to multiple sources of data within your enterprise and connected to data sources from around the world through the Internet. Due to these changes to your computer and its network, Excel has become limitless as a data analysis and reporting program. The creator of this website and tutorial has worked for 30 years in accounting and finance. He is certified by Microsoft as an expert in Excel and Access and will help you develop powerful solutions to do more with your business data. Pierre Leclerc |
Consulting Services in Excel
Rediscovering Excel's Functions and Formulas
Links to Other Resources on VBA