Build Engineering Apps in Excel (VBA)

Build an Excel-based application using VBA with a Z-factor calculation (Hall–Yarborough) as a working example.

‍

Covers core components of Excel app development, including VBA scripting, UserForms, and worksheet–interface integration.

‍

Key Features

• Cell naming for formula auditing
• Macro recording and VBA editing
• Goal Seek and Newton–Raphson implementation
• User-defined functions (UDFs)
• UserForms (inputs, controls, interaction)
• Worksheet ↔ form data exchange
• Auto-launch forms on workbook open
• Application-level controls (UI behaviour, visibility)
• VB script integration and app packaging

‍