Modeless userform
I have a userform which would benefit from being run
modeless. When running it modeless I need to update parameter lists in the userform, whenever the user wants to use it again, to reflect changes in books, sheets etc. Thought I could use the UserForm_Activate event for this, but it will not fire. Is there any event I could use for this? If not, how can I know when the user starts to use the form again, without her hitting any commandbuttons etc. on it, which might misfire due to not updated information. any help appreciated |
Modeless userform
Hi Jacob,
Go to http://www.bmsltd.co.uk/Excel/Default.htm and download the xls file named 'FormFun.zip'. It should help you. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Modeless userform
Maybe look at the mouseover event of the userform.
-- Regards, Tom Ogilvy "jacob" wrote in message ... I have a userform which would benefit from being run modeless. When running it modeless I need to update parameter lists in the userform, whenever the user wants to use it again, to reflect changes in books, sheets etc. Thought I could use the UserForm_Activate event for this, but it will not fire. Is there any event I could use for this? If not, how can I know when the user starts to use the form again, without her hitting any commandbuttons etc. on it, which might misfire due to not updated informatio any help appreciated |
All times are GMT +1. The time now is 02:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com