View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GUS GUS is offline
external usenet poster
 
Posts: 45
Default progress message

I have a macro at single module(not running from userform) which runs some
code for 3 minutes.
The code is jumping from sheet1 to sheet2 , check some values from sheet1
and copy them to sheet 2 .
The application.screenupdating is set to false .
How is it possible to show something (msgbox,form etc) at screen which
showing that the macro is running (not necessary progress bar)
(And Don't want the message at StatusBar)