Covers the must know Excel VBA fundamentals that allow you to solve your repetitive Excel tasks in seconds.
- Key topics include VBA Editor control, debugging, VBA language review, Excel automation, data processing, UDFs, reporting, and chart automation.
- 1000's of lines of useful code.
- Over 100 cutting edge examples like the ones below.
- Proven strategies we use to develop Excel VBA software.
Price: $75.00
Manual specs.
| Users: | Everybody |
| Format: | ADOBE PDF and Excel Files as zip file download |
| Details: | Covers beginning to intermediate Excel VBA topics |
| Book: | 1100+ pages with examples |
| Platform: | Windows 7 - Windows 10 |
| Sent: | Sent within 3 hrs after purchase Mon - Fri 8:30 AM - 5:00 PM PT |
| Versions: | Excel for Windows 2010-2019, Microsoft 365 |
What's in our manual.
Our Microsoft Excel VBA self study manual covers the basics of programming along with the main stream application of using VBA with Excel to solve data and analysis problems. It covers the programming fundamentals such as loops, variables, arrays and logic and controlling key Microsoft Excel components with VBA.
Our manual also covers key data processing strategies for data on single and multiple worksheets including building summary sheets and performing table lookups. It also covers automated chart construction, table formatting, workbook and worksheet control, and basic interface design on the worksheet including modeling. It uses real world examples that lets you start building useful Excel VBA macros right away.
< < < Scroll Picture > > >
Actual Manual Problems
* Our learning modules below come from our all-in-one manual: The Complete Excel Manual >
Learning Module 12: VBA Editor Overview | Module and Procedure Basics | Debugging
- VBA overview, what is VBA, how is it used
- VBA project and module overview
- What is a procedure and its basic structure?
- How to use key procedure types used in VBA
- VBA statement, syntax and keyword overview
- VBA editor overview, operation and window review
- Excel VBA macro protection
- How to manage VBA modules and type in them
- How to turn off and on key VBA Editor features
- VBA procedure calling rules
- Referencing and integrating code from other VBA projects
- How to debug your code using the VBA Editor
Learning Module 13: VBA Language Review | Automating Excel | Programming Solutions
- VBA variables, constants and arrays (declaring, scope and data typing)
- How to create and use expressions in VBA that perform calculations
- How to use different operators in your expressions (logical, arithmetic, string, comparison...)
- How to run VBA and Excel functions in your procedures
- How to use VBA arrays in your procedures
- How to create and use logic in your procedures
- How to create and use For and Do loops in your procedures
- What is an object, a property and a method
- How to correctly build object expressions that identify and command Excel objects
- How to run properties and methods in your VBA procedures
- How to create and effectively use Set statements in your VBA code
- How to build For…Each Next loops to loop through objects scanning for items
- How to use Excel/VBA on-line help
- How to use the VBA macro recorder to record Excel tasks in VBA
- How to use the Object Browser to look up Objects and their code
- How to provide error protection in your procedures
- Controlling Excel, Workbooks, Worksheets, Windows, Page Setup and PivotTables with VBA
- Controlling Ranges, Cells, Range Fonts, Range Borders, Range Colors with VBA
- Reading cell values, performing calculations, writing to cells
- Controlling Conditional Formatting, Data Validation, Sorting, Excel Tables and Queries with VBA
- How to lock on to changing worksheet data using VBA
- Basic data processing strategies for processing worksheet data using VBA
- How to use VBA to control and automate chart construction
- How to use VBA to control worksheet formulas and perform calculations
- How to build basic user interfaces in Excel by automating charts, drawing shapes and worksheet cells
- How to build model and analysis tools using Excel VBA
Learning Module 14: VBA Function Procedure Design | Custom Worksheet Functions
- Benefits of using Function procedures and User Defined Worksheet Functions (UDF's) for tasks
- Function procedure and UDF differences
- How to declare Function procedures and UDF’s in VBA
- How to create arguments for Function procedures and UDF’s
- How to call UDF’s from a worksheet formula
- Calling Function procedures from other VBA procedures
- Function procedure and UDF procedure interface design
- How to pass worksheet ranges as arguments to UDF's
- Returning scalar and array values from UDF’s to worksheet formulas
- Using VBA and Excel Worksheet functions in your VBA procedures
Learning Module 15: VBA Sub Procedure Design | User Interface Design Tips
- Benefits of using Sub procedures to automate various tasks
- Declaring Sub procedures in VBA
- Creating arguments for Sub procedures
- Calling Sub procedures from other VBA procedures
- Executing Sub procedures via the Macro dialog box
- Executing Sub procedures via shortcut keys
- Executing Sub procedures via graphics
- How to run Sub Procedures by assigning them to drawing shapes and pictures
- How to assign Sub procedures to shapes and pictures using VBA
- How to tell what picture or shape button was clicked using VBA
- Sub procedure interface design
- Sub procedure design tips
- Property procedure overview