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

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

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

--
HTH

Bob Phillips

"Joseph" wrote in message
...
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

Hi Joseph

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

HTH. Best wishes Harald

"Joseph" skrev i melding
...
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