Our advanced VBA manual gives you the knowledge to design sophisticated engineering and science
tools.
Over 1500+ pages of advanced Excel VBA topics covering multi-source data processing, text files,
chart construction, dashboards, userforms / ActiveX controls, events, systems modeling, databases, and Windows folder control.
Questions? 1.805.498.7162 Customers >
Microsoft Excel VBA Manual Specifics
For: |
Engineers and Scientists |
Format: |
ADOBE PDF and Excel Files
as zip file download |
Details: |
Covers beginning to
advanced Excel VBA topics |
Book: |
1500+ pages with examples |
Platform: |
Windows 7 - Windows 10 |
Sent: |
Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT |
Versions: |
Excel for Windows 2007-2019, Microsoft 365 |
Manual Introduction. Our Excel VBA self study manual shows you from an
engineering and science perspective how to use Excel and VBA to create advanced data analysis tools, advanced
system models, advanced database tools,
and advanced program interfaces.
It covers the fundamentals of Excel VBA
like using object, properties and methods; how to use logic, loops,
variables and the worksheet to develop data processing tools; automated
chart construction; and building UDFs and Sub procedures.
It also covers advanced topics like
accessing data on multiple worksheets and in multiple workbooks,
commanding userforms and ActiveX controls, developing event driven apps,
controlling Windows folders and files, communicating with other programs
and databases, and reading text files. The manual also discusses unique
topics like automating Solver, large scale system model development and
how to develop automated technical diagrams in Excel. It also discusses
how to package your tools in different Excel configurations and files
and how to develop your own custom Ribbon tabs.
Price: $129.00
Add to Cart
Our Refund Policy >
Learning Module 5: VBA Editor and Module Basics
- 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
- Macro protection review
- 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 6: VBA Language Review | Controlling Key Excel Elements with VBA
- 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 engineering and science 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, Range Fonts, Range Borders, Range Colors with VBA
- Controlling Conditional Formatting, Data Validation, Sorting, Excel Tables and Queries with VBA
- How to lock on to changing worksheet data using VBA
- How to use VBA to control and build charts
- Basic data processing strategies for processing worksheet data using VBA
- How to build basic dashboards in Excel by automating charts, drawing shapes and worksheet cells
Learning Module 7: VBA Function Procedure Design
- Benefits of using Function procedures and User Defined Worksheet Functions (UDF's) for engineering and science 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 8: VBA Sub Procedure Design
- Benefits of using Sub procedures for engineering and science 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
Learning Module 9: Interface Design Using Events, ActiveX Controls and Userforms
- Developing engineering and science GUI's and applications in Excel
- Creating graphics that automatically display technical data on the worksheet
- Assigning VBA Sub procedures to worksheet based graphics
- Creating event procedures that run automatically when something happens to Excel, a chart, a workbook or a worksheet
- Using ActiveX and Form controls to create GUI’s on the worksheet
- Creating event procedures for controls placed on a worksheet
- Review of creating userforms for technical programs
- How to create and control userforms in Excel
- Creating controls and graphics on userforms
- Commanding userforms and their controls with VBA
- Userform design tips
- Creating toolbars from userforms to control your Excel tools
- Creating a tab and button in Excel's Ribbon
Learning Module 12: Packaging Team Tools in Excel
- Storing and distributing Excel based tools in various Excel file types
- Constructing verified, standardized engineering and scientific tools in Excel
- Packaging/distributing engineering and scientific tools in workbook files
- Engineering and scientific uses of Add-Ins and workbook templates
- Constructing/packaging/distributing engineering and scientific tools in templates
- Constructing/packaging/distributing engineering and scientific tools in Add-Ins
- Distributing/maintaining Excel engineering and scientific tools on networks
- Engineering and scientific procedure library design (i.e. rapid prototyping and analysis)
- Developing security for Excel based software
Learning Module 13: Commanding Databases and Other Applications Using VBA
- Automation overview
- How to command other applications from Excel using VBA
- How to use CreateObject to control other applications
- Using DDE with VBA
- How to use DAO to communicate with Microsoft Access
- How to use ADO to communicate with Databases
- How to use ADO to communicate with Microsoft Excel
- How to use ADO to communicate with Text Files
- How to use the FileSystemObject in VBA to control the Windows file system
- How to loop through 100's of workbooks in folders using the FileSystemObject
- How to control Window's Shell
- How to use VBA to control Microsoft Word for reporting purposes
- How to use VBA to control Microsoft PowerPoint for reporting purposes
Learning Module 15: Design Optimization in Excel Using Solver
- Overview of design optimization
- How to layout an optimization problem in Excel
- Command and control worksheet overview
- How to drive multiple workbooks using Solver
- How to use Solver in Microsoft Excel
- Other design optimization packages for Excel
Learning Module 16: Constructing Large System Models in Excel
- How to determine your model equations and how they interact with each other
- Using Excel’s structure to organize system teams
- Laying out the system model in Excel
- Library workbook introduction and design
- Single and multi-workbook system model layout
- Using custom VBA worksheet functions and DLL's in your model