Cancel and Reset UserForm and macros

OK, this seems like it should not be that big of a deal, but I am going crazy
trying to figure this out. I am running Outlook 2003 on XP Pro machine. I
have created a userform that functions in all ways as it should, except when
the function of the form is done or if the user hits the cancel button.

I first had userform1.hide, that got rid of the form, but did not seem to
reset things in the VBA side of things. I then tried, reset, quit, terminate,
close. I have look up on MSND with no luck, googled this still no luck. I
have Sue Moshers book on programming and cannot find what I need to do this.

What I want to happen is the same thing that happens when in VBA and I click
the STOP(Reset) control button.

Is there a command line that I need to make this work? Or does this just not
matter? Please help, I am pulling my hair out. j/k

UserForm1.Hide() just make the form not visible. Any code on the form would
continue to run. You probably want to use Unload UserForm1 instead, which
will terminate the form.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"DStrong" <DStrong DeleteThis @discussions.microsoft.com> wrote in message
news:D16124E1-E511-4241-92BA-E5853C3CEA43@microsoft.com...
> OK, this seems like it should not be that big of a deal, but I am going
> crazy
> trying to figure this out. I am running Outlook 2003 on XP Pro machine. I
> have created a userform that functions in all ways as it should, except
> when
> the function of the form is done or if the user hits the cancel button.
>
> I first had userform1.hide, that got rid of the form, but did not seem to
> reset things in the VBA side of things. I then tried, reset, quit,
> terminate,
> close. I have look up on MSND with no luck, googled this still no luck. I
> have Sue Moshers book on programming and cannot find what I need to do
> this.
>
> What I want to happen is the same thing that happens when in VBA and I
> click
> the STOP(Reset) control button.
>
> Is there a command line that I need to make this work? Or does this just
> not
> matter? Please help, I am pulling my hair out. j/k