Using the Windows File Open Dialog When your VBA applications are required to open a file you can use the Windows Common Dialog Control to utilize the standard Windows Open file dialog. Add a…
Determine if an Application is Running Sometimes your VBA applications have to communicate with another Windows application. In those situations it is useful to know if the other application is…
Declaring Objects Working with objects in VBA can be somewhat tricky. They are declared similarly to a regular variable, but you also have to define a new instance of the object…
Commenting Blocks and Loops Using nested block and loop structures is often a necessary part of any VBA macro. Multiple nested structures can be very long and difficult to follow when…
Modal versus Modeless Forms A modal form is any form that prevents your macro from continuing, and restricts interaction with the parent application, until the form is closed. A modeless…
Collections and Arrays Collections in VBA are objects that can store groups of related items, much like an array. Unlike arrays, a single collection can store items of different…
Use Select Case instead of If-ElseIf When performing multiple comparisons it is easy to get trapped into using multiple If-ElseIf statements. While that will certainly accomplish the task a…
