After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...

To create a self-signed digital certificate that you can assign to your VBA scripted application, you need to use a Microsoft provided utility called SELFCERT.EXE.

Learn how to create a multi-step data entry form in Excel using VBA. Simplify data collection, reduce errors, and boost spreadsheet efficiency ...

Combine Excel’s functionality with PowerPoint’s “Merge Shapes” feature and VBA macros to create professional, application-style interfaces like dashboards, input forms, and menus.

Create a UserForm containing a dynamic number of controls and make sure they are being triggered by certain events. To achieve this result, we will use a UserForm and a class module, and assign any ...

Tips When creating .NET class libraries, name them anything you like. To reference them in VBA, use the name of the .NET class library as shown in the previous example.

Once users get a grasp of the relatively easy-to-use VBA syntax, many move on to Microsoft's Web application development platform, .NET.