Hello Gary,

Add a VBA Module to your project and place the code below in it. You
can the run it from the Macros Dialog (ALT+F8) when you need to display
the UserForm. Replace UserForm1 in the code with the name of your
UserForm.

Sub ShowMyForm()
On Error Resume Next
UserForm1.Show
End Sub

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=562333