Your code will run faster if you set a reference to another application's type library before you work with its objects. If you set a reference, you can declare an object variable representing an ...

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