Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display a message whil eprocessing
Hi, I am trying to display a message while processing, such as " Please
wait....saving in progress...". Is it possible ? Anybody knows the code? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display a message whil eprocessing
It depends on how you want this message presented.
A lot of people are satisfied with the Status Bar being updated. eg. Application.StatusBar = "Please wait....saving in progress..." Then at the end of processing Application.StatusBar = False -- Rob van Gelder - http://www.vangelder.co.nz/excel "broogle" wrote in message oups.com... Hi, I am trying to display a message while processing, such as " Please wait....saving in progress...". Is it possible ? Anybody knows the code? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display a message whil eprocessing
Is it possible to display the Message box ? Thanks
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display a message whil eprocessing
You might be interested in John Walkenbach's solution:
http://j-walk.com/ss/excel/tips/tip34.htm -- Rob van Gelder - http://www.vangelder.co.nz/excel "broogle" wrote in message ps.com... Is it possible to display the Message box ? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display a message whil eprocessing
Here is another example that is similar to the one the Rob noted:
http://www.pdbook.com/index.php/exce...ess_indicator/ ---- Regards, John Mansfield http://www.pdbook.com "broogle" wrote: Is it possible to display the Message box ? Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display a message whil eprocessing
Just to add, the built in Message Box will not work because it is Modal,
meaning that you code won't run while it is displayed. You can simulate a message box with a useform. In xl2000 and later you can show it as non-modal. More than you need for this particular question, but for reference in case you are unfamiliar: http://support.microsoft.com/default...b;en-us;162257 OFF97: How to Show a "Now Processing" Dialog While Macro Runs http://support.microsoft.com/default...b;en-us;829070 How to use Visual Basic for Applications (VBA) to change UserForms in Excel 2003, Excel 2002, and Excel 2000 http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. http://support.microsoft.com/?id=168067 File Title: Microsoft(R) Visual Basic(R) for Applications Examples for Controlling UserForms in Microsoft Excel 97 File Name: WE1163.EXE File Size: 161742 bytes File Date: 05/08/97 Keywords: kbfile Description: This Application Note is an introduction to manipulating UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual Basic for Applications macros that show you how to take advantage of the capabilities of UserForms and use each of the ActiveX controls that are available for UserForms -- Regards, Tom Ogilvy "broogle" wrote in message ps.com... Is it possible to display the Message box ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if, then display message | Excel Discussion (Misc queries) | |||
Display a message | Excel Worksheet Functions | |||
Display a message | Excel Worksheet Functions | |||
Error whil reading file | Excel Programming | |||
How to display a message box | Excel Programming |