Displaying a message when macros run!
 

Hi all!

Is there a way we can display a message on the screen when a certai
macro is performing a specific task?

I used the Msgbox "Generating File" option but this requires the use
to hit an 'OK' box to proceed. Can we have Excel flash/display
message quote "Generating FEV File................", without having th
user to hit any 'OK' button?

At the end of the execution, the flash message should automaticall
stop.

I would appreciate any help in this matter, thanks in advance.

Regds,

Arun.

Vtec Corp

--
Message posted from http://www.ExcelForum.com

Displaying a message when macros run!
 

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/