Close userform without clicking a button

[dimitri]

Hi,
I have a userform with a button that says "Save Changes" with code attached to it. when the user hits the "Save Changes" button, I want a box to briefly appear saying "Your changes have been saved".

Currently, I have that box as a userform. I'm having trouble getting the box to close automatically. I tried putting the application.wait code in the initialization section of the userform followed by Unload Me, but I get an error.

Any help would be appreciated.

 

[VoG]

Try in the userform's code module

Private Sub UserForm_Activate()
Application.OnTime Now() + TimeSerial(0, 0, 3), "CloseUserForm"
End Sub

and in a regular module

Sub CloseUserForm()
UserForm1.Hide
Unload UserForm1
End Sub

 

[dimitri]

I tried the first code but the user form doesn't go away automatically. I moved my original code from the "initialize" section to the "activate" section of the userform's code modual and it works the way I want it to.

Private Sub UserForm_Activate()
Application.Wait Now + TimeValue("00:00:02")
Unload Me
End Sub

I didn't know about the "Activate" section of the module. what differeciates it from "Initialize"?