Excel VBA Handbook for Engineers and Scientists

At a quick glance.

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.

It's a 1000+ page manual, there's a lot of 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.

For:	Engineers and Scientists
Format:	ADOBE PDF and Excel Files as zip file download
Details:	Covers beginning to intermediate Excel VBA topics
Book:	1000 + pages with examples
Platform:	Windows 7 and above
Sent:	Sent within 3 hr after purchase Mon-Fri 8:00 AM - 7:00 PM CT
Versions:	Excel 2013 for Windows and above