Excel VBATutorial                      Tutorial on Excel macros

 

Excel VBA Macros

Excel Macros Table of Contents

Excel Visual Basic Editor

Excel Macros Vocabulary

Excel Userforms

Excel Consulting

Excel Tutorial on Macros

Email to excel-vba.com

Consulting Services in Excel and VBA

Excel VBA Consultant

My professional and academic backgrounds are in accounting, finance and management. My field of expertise is business data analysis and my tool is Excel.

I have been tested by Microaoft and certified as Expert in Excel and Access.

I have been using Excel for the last 30 years and working as Consultant in Excel for over 10 years. I design simple formulas, simple macros, automated reports and complex business data analysis and business models.

Whatever your centralized database, accounting, sales or production management program, you can extract data from it. You can then bring the data into Excel and develop significant analyses and reports to help you make rapid and crucial business decisions.

Your goal is to save time and money....I can help you achieve your goals

Peter

Serving clients online since 1997
Mobile: 613-749-4695 (Peter)
Email: peter@excel-vba.com


Recent Projects


Free Quotations

I can show you how to do it, I can help you do it or I can do it for you
It is your choice


All the Lessons

Lesson 1: Visual Basic Editor (VBE) in Excel, Lesson 2: The Project Window in the Visual Basic Editor of Excel, Lesson 3: The Properties  Window in the Visual Basic Editor of Excel, Lesson 4: The Code  Window in the Visual Basic Editor of Excel, Lesson 5: Developing Macros in the VBE, Lesson 6: Testing  Macros in the VBE, Lesson 7: Excel Macro Recorder, Lesson 8: Macros Help and Assistancem, Lesson 10: VBA Security and Protection, Lesson 11: VBA Coding Tips, Lesson 12: Dealing with Errors, Lesson 13: Working with  the Application, Lesson 14: Working with  the Workbooks, Lesson 15: Working with  the Worksheets, Lesson 16: Moving Around the Worksheet, Lesson 17: Working with  Message and Input Boxes, 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 external data and SQL, Lesson 23: Working with  Windows and  other Microsoft Programs FROM Excel, Lesson 24: Forms (Userforms) in VBA for Excel, Lesson 25: Userforms Properties and VBA Code, Lesson 26: Properties and VBA code for Command Buttons, Lesson 27: Properties and VBA code for Labels, Lesson 28: Properties and VBA code for Text Boxes, Lesson 29: Properties and VBA code for Combo Boxes, Lesson 30: Properties and VBA code for List Boxes, Lesson 31: Properties and VBA code for Check Boxes, Option Buttons and Frames, Lesson 32: Properties and VBA code for Spin Buttons, Lesson 33: Excel Image Controls


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.

 

Excel Tutorial on Macros

Excel VBA Macros

Excel Macros Table of Contents

Excel Visual Basic Editor

Excel Macros Vocabulary

Excel Userforms

Excel Consulting