Join Curt Frye for an in-depth discussion in this video Examining the Excel object model, part of Up and Running with VBA in Excel.
Object-oriented programming languages, such as Visual Basic for applications, let …you create and manipulate objects using the Properties, Methods and Events. …Microsoft Excel is a huge program with thousands of objects, but the program …team defined every element of Excel, from the application itself to the …individual cells, as object you can manipulate using VBA commands. …Taken as a whole, those definitions are called the Excel Object model. …It's not practical for me to show you the entire Excel Object model. …The authors of the book Excel 2007 VBA Programmer's Reference, from Wrox Press, …printed more or less the entire Excel 2007 Object model in their book, and it …took up 336 large-format pages. …Rather than try to work through all that material, I'll focus on a few of the …most common objects and describe how they relate to elements within Excel. …Let's start with the Application object, which represents the Excel program itself. …The Application object has many Properties, Methods and Events, so I'll concentrate on a few examples. …
- Working in the Visual Basic Editor
- Adding code to a macro
- Creating, exporting, and deleting code modules
- Declaring and using variables
- Managing variable scope
- Defining arrays
- Managing workbooks and worksheets with VBA
- Repeating tasks with loops
- Debugging VBA code
- Cutting, copying, and pasting cell data
- Running and triggering event procedures
Skill Level Advanced
1. Introducing Visual Basic for Applications (VBA)
2. Defining Variables, Constants, and Calculations
3. Adding Logic to Your VBA Code
4. Debugging Your VBA Code
5. Managing Workbook Elements and Data in VBA
6. Adding Advanced Elements to Your Workbook
7. Using Excel Events in Your VBA Code
8. Putting It All Together
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.