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




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

Maybe you can use this Nigel

Private Sub UserForm_Activate()

End Sub

Private Sub UserForm_Deactivate()

End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Nigel" wrote in message ...
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




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---