Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Formula for displaying a message | Excel Discussion (Misc queries) | |||
Stop displaying a message because of a formula | Excel Worksheet Functions | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming | |||
Displaying a status message | Excel Programming | |||
Displaying a Message and a Beep | Excel Programming |