UserForm Events
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 =--- |
UserForm Events
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 =--- |
All times are GMT +1. The time now is 08:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com