Start learning with our library of video tutorials taught by experts. Get started
In Up and Running with VBA in Excel, Excel and VBA expert Curt Frye introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance Excel performance and efficiency. This course introduces the Visual Basic for Applications programming language, covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel 2007 object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.
Hi. I'm Curt Frye. Welcome to Excel: VBA in Depth. If you need to manipulate data and want to go beyond to what the Macros feature offers then this course is for you. I'll be showing you how to create custom macros and enhance the power of Microsoft Excel. I'll begin by introducing the Visual Basic for applications programming language. Then, using that knowledge as a base, I'll demonstrate how to create subroutines and functions to hold your code. I'll also show you how to discover more information about the Excel programming environment from within Visual Basic Editor.
We'll enhance your ability to build custom solutions by showing how to declare variables and assign values to them, manipulate workbooks, worksheets and cell ranges using object variables, and write efficient code using shortcuts built-into VBA. I'll show you how to control which statements Excel runs by using Program Logic, run procedures when specific events occur, and analyze your code to discover and fix any errors that might occur. In short, I'll show you how to build custom solutions using Excel's robust programming capabilities.
Let's get started with Excel VBA in Depth.
There are currently no FAQs about Up and Running with VBA in Excel.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.