UserForm Events

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

Hi All

I have two user forms that can be toggled by using userform.show and
userform.hide. I require both to remain in memory so I do not unload them
after using userform.show.

My question - is there an event that is triggered when a userform is either
shown or hidden? Or is there a way I can create this with code?

TIA
Cheers
Nigel
 
Maybe you can use this Nigel

Private Sub UserForm_Activate()

End Sub

Private Sub UserForm_Deactivate()

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh form 1
Userform Issue 3
Sendmail: Problem when used after a Userform 12
Program Flow and Buttons 2
Call UserForm procedures from another workbook 2
Call a Control_Click Event when UserForm is Initialized 1
Help. where's the #@%$&^ userform? 7
Continouse Calc while userform is shown 4

Back
Top