![]() |
Keep userform visible, but return control to calling routine
In case anybody is interested, I've answered my own
question, by making the UserForm "modeless" with the following calling syntax: MyForm.Show vbModeless -----Original Message----- Hello, I'm trying to load/display a UserForm from a VBA routine and keep it visible, but return control to the calling routine, which will periodically update information in the UserForm. At the end of the routine, I will unload the UserForm. The problem is, I cannot figure out how to return control to the calling routine without unloading the UserForm. An example of what I'm trying to achieve is Chip Pearson's ProgressReporter routine, if that helps explain the situation. Thanks in advance for any help. Ryan . |
All times are GMT +1. The time now is 08:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com