Build your own Apps with Excel forms and VBA

In this tutorial, we create a mini-app to calculate the Z-factor via the Hall-Yarborough correlation as an example.

Why is this example good? Because it covers a lot of ground - You'll learn:

• Naming cells for formula auditing
• Recording macros in Excel
• Editing VBA
• Using Goal Seek and VBA with Newton-Raphson optimization
• Creating user-defined functions
• Building UserForms: labels, text boxes, command buttons
• Transferring data between an Excel worksheet and a form
• Opening a form by default when Excel starts
• Hiding the Excel application
• Creating a VB script
• Changing the app icon