Excel VBA Handbook for Engineers and Scientists - Manual

Manual quick facts.

• Comprehensive 1000+ page manual with detailed illustrations, coding instructions, and 100's of solved examples.
• Explains in detail how to use the Excel VBA language and also how to use the VBA Editor, VBA modules, and code debugger.
• Covers how to control key Excel elements with VBA like workbooks, worksheets, ranges, shapes, formats, functions, and Excel's data tools.
• Shows how to use Excel VBA to perform tasks like copying and pasting data; automating calculations; creating and formatting reports; filling tables, and building various charts.
• Covers how to automate illustrations using shapes and build UIs to run your code and models.

More about the manual.

Our manual covers how to use the VBA language and the essential Excel VBA topics needed for solving engineering and science problems. It explains in detail the VBA fundamentals you need to know to start writing high powered macros.

VBA topics covered include how to use data types, variables, constants, arrays, operators, expressions, loops, logic, and functions in your code. Also covered is a complete review of the VBA Editor, how to debug your code, and how to use the different types of VBA modules. There is also an in depth discussion about Excel objects, properties, and methods and how to type and use them in your code.

The manual also covers how to use VBA to control key Excel components like workbooks, worksheets, ranges, charts, formats, formulas, shapes...etc. It also covers how to automate key Excel data features like PivotTables, Sort, AutoFilter, Excel Tables...etc.

Important VBA engineering and science topics covered include problem formulation on the worksheet, automating calculations, modeling, data processing, report table construction, custom worksheet functions (UDFs), and building UIs to run your programs. It uses real engineering and science examples that show you how to start building Excel VBA macros right away.

Some key manual topics.

• Complete review of the VBA language including variables, loops, constants, expressions, logic, functions, and arrays
• Review of the VBA Editor, VBA modules, and debug tools
• How to create and use Sub and Function procedures in VBA
• How to run Sub procedures using the Macro dialog box, shortcut keys, drawing shapes, and pictures
• How to automate calculations and use Excel worksheet functions in your VBA code
• Using objects, properties, and methods in your VBA code to control Excel and other programs
• How to track multiple Excel objects effectively in your VBA code without them being active
• Using Excel / VBA on-line help, the VBA Macro recorder, and Object Browser to look up your VBA code
• Controlling Excel, workbooks, worksheets, windows, and page setup with VBA
• Controlling ranges, names, formulas, fonts, borders, and cell colors with VBA
• Controlling Conditional Formatting, Data Validation, sorting, Excel tables, and filters with VBA
• Using VBA to insert, delete, filter, and format table rows and columns
• How to create and fill in worksheet tables and reports using Excel VBA
• Using Excel VBA to process data on single and multiple worksheets
• How to use VBA to automate chart construction
• Automating technical diagrams using drawing shapes and VBA
• Controlling and managing models with Excel VBA
• How to build and run custom worksheet functions (UDFs) from worksheet formulas
• Using UDFs to build sophisticated models and run numerical analysis techniques
• Basic UI design for running your VBA code and models

Manual specifications and download.

Associated classes.

• Excel VBA for Engineers and Scientists >
• Excel VBA Data Analysis for Engineers and Scientists >