I have a VBA macro, and wanted it to report statistics on its progress as it runs, on a user form, that i periodically update within a loop with new numbers. The form is shown with modal=False. But, it does not stay on top. In fact, it flashes throughout the macro, for a moment, visible, then not visible, then it comes back. Also, it is usually blank, you just see the form's window's title bar and outline, but just blank content within the form. Every time i actually update the form, i do Form.repaint, and at that time, you actually see the labels and statistics on the form, briefly, before it disappears again.
Can anybody tell me how to keep this form on top, and painted, while the macro runs? Or, in alternaive, how is it usually handled to have progress visible and indicated during a macro? I do not want a modal dialog that i have to dismiss, as the macro can run for a long time.
Thanks!
Tom
Can anybody tell me how to keep this form on top, and painted, while the macro runs? Or, in alternaive, how is it usually handled to have progress visible and indicated during a macro? I do not want a modal dialog that i have to dismiss, as the macro can run for a long time.
Thanks!
Tom
