ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Keep userform visible, but return control to calling routine (https://www.excelbanter.com/excel-programming/274931-keep-userform-visible-but-return-control-calling-routine.html)

Ryan Poth[_2_]

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