Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get userform Cancel button to invoke Exit Sub in calling macro? | New Users to Excel | |||
Calling a Userform from a Predefined Variable | Excel Worksheet Functions | |||
Calling function from a userform | Excel Discussion (Misc queries) | |||
UserForm Control | Excel Programming | |||
UserForm Control | Excel Programming |