Powerful Excel Macros (VBA)
VBA is the programming language used within Excel to develop macros
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 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 form is a small or large dialog window that allows the user to submit values that will be used by the macro. If you need to develop userforms, you will add controls (command buttons, text boxes, list boxes and others) to these forms. Learn all about these userforms and controls in section 3.
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 the Application
- Lesson 13: Working with Workbooks
- Lesson 14: Working with Worksheets
- Lesson 15: Range and Cells
- Lesson 16: Message Boxes in VBA for Excel
- Lesson 17: Working with Database and Filters
- Lesson 18: Working with Errors
- 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: Userforms and Controls Properties
- 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 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
to data sources from around the world through the Internet.
Due to these changes to your computer, Excel is limitless as a data analysis and reporting program.
The creator of this website and tutorial has worked for 30 years in accounting and finance. Certified by Microsoft as expert in Excel and Access he will help you
use all of your business data to transform it into sound business decisions automatically.
Pierre Leclerc
|
|
