How to display a form- to show status of the running program

[Joseph]

I want to display a form(excel) while running a program through a macro.

The form shows the program running status like"calculation in progress....."
while the macro is running the program in the excel (Just an identification
for the user that the program is running safely).
How to call and display the form (with labels showing status) in the module
of the macro.

Regards,
Joseph J

[Bob Phillips]

Take a look at John Walkenbach's site
http://j-walk.com/ss/excel/tip*s/tip34.htm

--
HTH

Bob Phillips

"Joseph" <Joseph@discussions.microsoft.com> wrote in message
news:F996D56C-6D5C-4083-82F8-A756CF5886E0@microsoft.com...
> I want to display a form(excel) while running a program through a macro.
>
> The form shows the program running status like"calculation in
progress....."
> while the macro is running the program in the excel (Just an
identification
> for the user that the program is running safely).
> How to call and display the form (with labels showing status) in the
module
> of the macro.
>
> Regards,
> Joseph J

[Harald Staff]

Hi Joseph

See if
http://j-walk.com/ss/excel/tips/tip34.htm
is of help.

HTH. Best wishes Harald

"Joseph" <Joseph@discussions.microsoft.com> skrev i melding
news:F996D56C-6D5C-4083-82F8-A756CF5886E0@microsoft.com...
>I want to display a form(excel) while running a program through a macro.
>
> The form shows the program running status like"calculation in
> progress....."
> while the macro is running the program in the excel (Just an
> identification
> for the user that the program is running safely).
> How to call and display the form (with labels showing status) in the
> module
> of the macro.
>
> Regards,
> Joseph J