Hi
Use the statusbar
Application.StatusBar = "I am working"
' your code
Application.StatusBar = False
Or a few other options
http://www.j-walk.com/ss/excel/files/developer.htm
Control the LED Display in the StatusBar
http://www.j-walk.com/ss/excel/tips/tip34.htm
Displaying a Progress Indicator
--
Regards Ron de Bruin
http://www.rondebruin.nl
"aiyer " wrote in message ...
Hi all!
Is there a way we can display a message on the screen when a certain
macro is performing a specific task?
I used the Msgbox "Generating File" option but this requires the user
to hit an 'OK' box to proceed. Can we have Excel flash/display a
message quote "Generating FEV File................", without having the
user to hit any 'OK' button?
At the end of the execution, the flash message should automatically
stop.
I would appreciate any help in this matter, thanks in advance.
Regds,
Arun.
Vtec Corp.
---
Message posted from http://www.ExcelForum.com/