|
|||
|
|
|
|
|
|
VBA for Excel (Macros)
|
|
|
Excel hasn't changed much since the 1980'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 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. Let me offer you my 30 years of experience in accounting and finance and my expertise in Excel certified by Microsoft to help you use all of this data and transform it into sound business decisions. Peter Leclerc |
For users of Excel 2007:
Installing the Visual Basic Editor in Excel 2007 from your Office CD
Section 1: The Programming Environment in Excel: 10 lessons
This section is about recording, writing, modifying and testing macros in the Visual Basic Editor. You will learn about security and discover "events" (an event is what starts the macro).
- 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
Section 2: The Programming Vocabulary and Rules of VBA for Excel: 13 lessons
Developing a macro is like talking with Excel and to do so you need to use a language called VBA. There are over a thousand VBA words but you will really need only 100 to talk with Excel about workbooks, worksheets, cells, databases, loops and to develop simple and powerful macros.
- 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
Section 3: The Userforms or Dialog Windows in VBA for Excel: 10 lessons
The form is a small window that allows the user to submit values that will be used by the macro. To these forms you add controls (command buttons, text boxes, list boxes and others).
- 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
You can surf this entire website and find free and useful ideas and tips
on developing macros and using VBA to create powerful programs in Excel.
Better yet you can download the
Tutorial on VBA for Excel (Macros)l
and you will find 10 times more tips and ideas
plus practical examples in many Excel spreadsheets
Serving clients online in USA and Canada for the past 15 years
Mobile: 613-749-4695 (Peter)
Email: peter@excel-vba.com
Education: B.A. in Finance, Masters' in Resource Management and International Public Administration, Microsoft Certifications in Excel and Access
Clients: Merck Pharmaceuticals (New Jersey ), SCI (Texas), Atlas Paper Mills (Florida) , Bombardier (Valcourt), National Bank of Canada (Toronto) and many small business owners, investors and free lance professionals around the world.
|
|
|
|
[123.htm]
