Excel VBA Problem Solver Manual

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 real world examples like the ones below.
• Proven strategies we use to develop Excel VBA software.
• Buy a manual now, apply the price towards a class later. They are free with our classes.

Manual specs.

What's in our manual.

Our 1100+ pg Excel VBA manual covers the VBA language along with using Excel VBA to solve data, calculation, and formatting 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.

Click to enlarge, scroll < > if hidden.

Must know Excel VBA topics covered in the manual.

• VBA overview, what is VBA, how to use it
• VBA Editor, VBA Module, VBA debugger, and procedure review
• Complete VBA language review including constants, variables, arrays, functions, logic, and loops
• Executing Sub procedures using the Macro dialog box, shortcut keys, shapes, and pictures
• How to use Excel objects, properties, and methods in VBA
• Running Excel worksheet functions in VBA to process data and perform calculations
• Finding and tracking multiple Excel objects at once in your VBA code that are not active
• How to use Excel/VBA on-line help, Macro recorder, and Object Browser to look up Excel object code
• Controlling Excel, workbooks, worksheets, windows, page setup and PivotTables with VBA
• Controlling Ranges, Cells, Names, Formulas, Fonts, Borders, and cell colors with VBA
• Using VBA to read cell values, perform calculations, and write to cells
• Controlling Conditional Formatting, Data Validation, sorting, filters, Excel Tables and queries with VBA
• Using VBA to insert, delete, copy and paste, and format table rows and columns
• How to fill in worksheet tables and forms using Excel VBA
• Using VBA to process data on single and multiple worksheets
• How to use VBA to control and automate chart construction
• Constructing UIs from drawing shapes, pictures, and worksheets to run your VBA code
• How to make custom worksheet functions (UDFs) the process data and perform calculations

Price: $75.00