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.

Microsoft Excel is a powerful tool that can be used for data manipulation. To make the most of the software, you need to use VBA. Visual Basic for Applications, or VBA, allows Excel users to create ...

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 ...

In this article you will learn how to create checkboxes which are automatically linked to particular cells. VBA doesn't allow the creation of multiple checkboxes at once. You can manually link ...

While minimizing Excel to open an existing document in Word -- or to create a new one -- is relatively quick and simple, using Visual Basic for Applications, or VBA, you can program macros or ...