Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



Display A Message While A Macro Is Running

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Is there a way to display a message during the entire time that a macro is running? I have a macro that takes a little while to run. I have worked with enough users that I know they will get impatient if they don't see a message stating that it is still processing. I don't want the user to interact with the message (like a msgbox), I just want to be able to display a message. If possible, I may want to change the message that is displayed during the process to show progress.

Thanks for any help.

View Answers     

Similar Excel Tutorials

Stop a Macro from Running in Excel
How to stop a macro from running after it has started. This method uses the keyboard and has nothing to do with th ...
How to Add a New Line to a Message Box (MsgBox) in Excel VBA Macros
I'll show you how to create a message box popup window in Excel that contains text on multiple lines.  This allows ...
Run a Macro When you Click a Button in Excel
Make a macro run when you click a button in the worksheet in Excel. This allows you to create a button and put it a ...
Loop through All Worksheets in Excel using VBA and Macros
Ill show you how to loop through all of the worksheets in a workbook in Excel using VBA and Macros. This only take ...

Helpful Excel Macros

Pop-Up Message Box When a Cell Reaches a Certain Value or Contains Certain Text
- This macro will display a message box in excel when a cell reaches a certain value or contains certain text. This means
Add an Input Message to a Cell - Message Appears When the Cell is Selected in Excel - Data Validation Macro
- Add data validation input messages to cells in Excel with this free Excel macro. These messages appear when a specific
Pop-Up Message Box When a Range of Cells Reaches a Certain Average
- This macro will display a message box when the numbers within a range of cells reaches an average of 5. The current mac
Macro to add a New Line to Message Box Pop-up Windows in Excel
- This is a very simple Message Box, pop-up window, macro for Excel that illustrates how to put new lines, the same thi
Delete Multiple Named Ranges Quickly
- This macro will allow you to delete multiple named ranges very quickly. When you run this macro, a message box will pop-

Similar Topics







Hello,

Is there a way to Display a message to the user while an application is running?

For example, while a macro is doing it's thing, at it takes some time for the macro to run, instead of showing everything that's going on, could a message be displayed that says "Your Query is Running" ? (just as an example)

Thanks very much for any help!


I have a Macro which takes about 2 mins to run, can anyone provide me with the VBA code which will produce a message on the screen to show up "something like "macro running" during the macro run time.

A more ambitous request though not as crucial - is there a way of showing a progress bar or % coplete, indicating how far through. the Macro has run?


thanks




Hello,

I've created a macro that runs a process that I need to do on a daily basis. This process does a bunch of tedious tasks and then calculates a total number at the top of the page, as well as a few other metrics. When the process is complete, my worksheet displays a these totals at the top. I want to add a message box to the end of the macro that will pop up when the macro is finished running. I only know how to make the message box display a constant string of text - saying something like "Process complete."

What I would like to do is make the macro display a variable value, for example, one of the "total" macros that's displayed on my worksheet. Ideally, when the macro has run its course, the message box would pop up and say, "Process complete. The total is X", where "X" is whatever the macro has calculated as the total for that day, which is displayed in cell E5.

How can I make my message box incorporate a variable piece of information that's located in the same cell every time?

I'm a VBA beginner, and I want to express my gratitude in advance for any advice/suggestions. Thank you!

-Student1990

one of my macros takes a couple of secs to execute and the hourglass appears, during that time I would like a "working.." message to display on the screen to alert the user that everything is proceeding normally, is there an easy way to do this?

ie:

- display "working " message
- my macro gets executed
- close "working..." message

thx. for any help!


Hello, all. I have a spreadsheet with several macros that are activated by form buttons, and change things behind the scenes, and it occurs to me that the users may not know that a macro has successfully completed.

Is there a way I can display a dialogue box to the user when the macro finishes running with a custom message like "Macro Change is now finished, you may enter your data"?

Thank you in advance for your help.


Hello, all. I have a spreadsheet with several macros that are activated by form buttons, and change things behind the scenes, and it occurs to me that the users may not know that a macro has successfully completed.

Is there a way I can display a dialogue box to the user when the macro finishes running with a custom message like "Macro Change is now finished, you may enter your data"?

Thank you in advance for your help.


Hi everyone,

When I run one of my macros, I display a message box at the start to warn the user to close some files before running. When the user clicks OK, the macro continues, but the message box remains. #1 Is there a way of removing this so it doesn't display throughout the run?

Also, #2 if anyone could point me to a good and light procedure to display a macro run time status bar, I would be grateful. I have created a basic one in the past, but it required quite a lot of additional code to be inserted into the original macro. It was also quite non-linear, which made it difficult to reasonably gauge time to completion.

Many thanks,

vcoder


Dear Friends,

I am trying to create a form in VBA . My concern is

1) A message box should be displayed after every 15 minutes ( any message, say hi)

2) After the message , the timer should start again and re-display the same message again after 15 minutes ... the message loop should continue until i close the form.

Thanks in advance.


Hi,
I'm running a macro that can take a while so I want to let the user know that the macro is running OK. I've put the following line in my code

MsgBox "Searching BOM's", vbInformation

The problem is that it requires the user to press OK before it runs the macro, then the box goes off and the macro runs. What I really want to do is display a box that doesn't require user input, and stays on the screen while the macro is running and goes off automatically when the macro is finished. When the macro is finished it will either show a page of search results, or another message box saying Not Found, which requires an OK response from the user.

Hope this makes sense. Thanks for looking at my question, any help greatly appreciated.


Hi,

as you probably already know, when you insert function Code:

MsgBox


in VBA then VBA takes a pause while that message box is shown. After you press OK, Yes or some other button the message box disappears and VBA continues to run macro further.
But my question would be: is it possible to use some kind of function, that VBA ignores the message box and continues running macro further without pressing anu button on message box?

Thanks in advance.


Hello

Is it possible to display a message without using the MsgBox command.

I would like to enhance the flow of my process and having to click on the "OK" box of a MsgBox is not practical

Info could be displayed for 3 seconds then disapear

Martin


Hi all, I was wondering if anyone can help me with this query:

I want to display a message box when a workbook opens (displaying copyright information, that sort of thing). I have tried using a macro run on Workbook_Open, however Excel 2007 helpfully blocks macro content until the user has specified that macro should be enabled (or not, as the case may be) - this means they may not see the copyright message.

I want to circumvent that, hence why I was wondering if there is a solution without resorting to a macro.

It does not necessarily have to be a message box, just something that is visible to the user when the workbook opens.

Thanks in advance

Hello,

My macro is importing a large amount of data.
So while it's importing the data I want to display a message to the user i.e. 'Data importing...please wait'.
For this I created a user form & am using it like this

WinUserMsg.Show
.
.
. data import code
.
.

WinUserMsg.Hide


Now the problem is this user message box opens but the text inside is not displayed. Instead a white blank window is displayed.

Would appreciate your comments.

Regards
Wasim


Or possibly not a userform question, you decide.


What I'm trying to achieve is a status message appearing on screen while a macro runs (just something like "Processing, standby"). The problem is I have no space on the worksheet to display this message so I need it to appear in a box over the top of the data entry area.

I thought of having a hidden text box that I just un-hide in VBA and then issue a .visible = false command at the end of the macro but while that works fine in excel 2003 it doesn't seem to in excel 2007 (needs to work in both).

I then thought of having a userform with my message on it that I can display with show.userform but then the macro pauses until the userform is unloaded again so that's out.

Can't user a msgbox either cos the macro will pause until 'ok' is clicked.



Is there a simple solution and am I being stupid here?


Hi,

I have a macro that updates alot of data on different tabs and takes a minute or two at most.

This is used by other people as well and I wanted to find out if you can display a picture or user form in front of the macro with a message for example "please wait while processing", while it processes behind it.

Thanks Dave




Hi all,

I've a workbook with a few sheets where column A=old partnr, B=old name, C=old E-nr, D=comment, the columns E, F, G and H is the same but for the new part.

I want to add a search box where I can search for a string, could be the name, partnr, new or old, or what ever, and if it's found I want to display the entire row in a message box, if the search string is match more than once, I want the message box to display all matches.

I hope it make sence, I appreciate any help.

Thanks

Hi folks...

Is there a way to display a message box such as "Report Building - Please Wait" without the user having the need to intervene? At the end of the process, clear the message box?

Much Thanks...


Hi, everyone...
I have a simple question: When you create an e-mailing macro, the resulting e-mail issues a warning message asking the user to agree in sending the message. No problem here.

My question: is there any way to force the display of that message smack in the center of the screen, over whatever is shown?

The reason I am asking is because many of my users have a zillion minimized apps and many a times the warning message ends up also in the minimized tray and they miss it.
I know, the indicator will flash in orange and be noticeable to sharp eyes, but you don't want to know the kind of users I deal with...
Chuck


Hi,

I am writing a macro that calls a COM utility that takes a couple of minutes to do a calculation. E.g., my macro has code like

dim a as MyComObject
set a = new MyComObject
' some code here to initialize a
a.property1 = 5
a.property2 = 6
'etc
'now tell a to do its calculation
a.run 'this takes a long time

When I execute the last command, Excel displays an hourglass for 2-3 minutes. I'd like to be able to display something (could be in a spreadsheet cell, or in a userform, or anywhere) that flashes a message like:

a is still calculating! it's been calculating for 10 seconds!

Then:

a is still calculating! it's been calculating for 20 seconds!

etc.

The purpose for this is to placate the user, so I am very flexible in terms of what I would display and how I would display it--if, for example, I can't accurately time 10 seconds, 20 seconds, etc, that is ok--it would be useful to have _something_ changing on the screen while the COM utiltity is running.

Thanks in advance!




Talk about terse! I was just running a macro, which I know takes a long time. It finished the main processing, but when it got to the end I got an error message box that was totally blank! No message, no error number, not one character of text, just the red-X symbol you get with MsgBox/vbCritical, an OK button and a Help button. Its title is "Microsoft Visual Basic for Appli..."

Anyone seen this? Anyone know what it means?
BlankError.gif

How can I have the text that is displayed in a custom popup message box to display with line breaks as opposed one continous message?


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




I need to open a message box that requires the user to click OK to close it. I need the message box to open automatically every 170 minutes after opening the workbook until the workbook is closed. Any help would be greatly appreciated.

I tried running the macro for the message box from a true / false statement based off of variable formulas. It worked OK except the message box would sometimes open up when a value in certain cells changed but did not change the true / false statement. I think a timer may be easier but can't find what I am looking for.


I want to emulate the standard "Msgbox" (with OK or Cancel buttons), but allow the user to scroll the worksheet while the message is displayed. Following previous threads here, I have created a simple user form and display it as modeless. I am using a form property to identify which button has been clicked, but this is just not picked up. With a combination of Screenupdating and Repaint, I have got the form to display, but the application does not wait to process the button and continues to later code. How can I display a message to the user, allow the user some degree of access to the worksheet, but not continue processing through the code until the user selects an action button?


Hi,

i would be grateful for any help - i have recently upgraded from office XP to 2003, and want to display a simple input message to guide users entering data. I selected the cell range & slected data / validation / input message and entered the text.

When i place my cursor in one of the selected cells, no message appears. In case there was a chnage from XP i added in some data validation and an error message - i get the correct error message if i enter incorrect data, but still no Input Message!

I have checked the Tools / options checkboxes and all seem to be ok - i guess this must be a tickbox thing, but i can't locate it. I've tried the manual & this site message board, as well as the Help, without any luck. And now it's starting to bug me! So i decided to register......

All suggestions welcome!!

Trevor