Display Pop Up Message while a Subroutine Executes and close when Exit Sub

**stubbsj** · 06-01-2012, 04:45 PM

I'm looking for a simple way to display a pop up message while a lengthy subroutine executes and then closes when exit sub?

Please Login or Register  to view this content.

Thanks for the help.

Jim

**Medpack** · 06-01-2012, 04:56 PM

Hi Jim,

Msgbox's are always displayed as modal (e.g. they hault code and wait for user input before proceeding). The easiest way to get around this would probably be to create a custom userform, have it display the message you want, and call the userform using vbmodeless (e.g. non-modal). This allows all other functions to continue while being displayed.

If you provide a sample workbook and what messages you want to appear, I could create a userform for you and show you the correct syntax to call/close it.

Hope you find this helpful,
Nick

**abousetta** · 06-01-2012, 05:00 PM

Hi Jim,

The best example for this are progress meters (bars). They show the user how much progress has happened, without stopping the code from continuing to run. In the Water Cooler there is a thread that I started dedicated to this. In it you will find many examples.

Let us know if you need any further assistance.

abousetta

**stubbsj** · 06-01-2012, 05:03 PM

Thanks Aousetta. Do you have a link to the Water Cooler and the thread you mention?
Jim

**abousetta** · 06-01-2012, 05:09 PM

Here is the link...

http://www.excelforum.com/the-water-...cator-bar.html

**stubbsj** · 06-01-2012, 05:15 PM

Thanks Abousetta. I'm sure I will find something in here!

**Fettertiger** · 06-01-2012, 05:18 PM

Hi,

it is pretty simple if you use Userforms. To give it a kick-start I have included a Userform into the attached worksheet.

Hope this is what you needed

Regards

Theo

**stubbsj** · 06-01-2012, 05:23 PM

Thanks Fettertiger. I'll give it a try as well.

**stubbsj** · 06-01-2012, 05:24 PM

Thanks Medpack. Lot's of good advice.

**royUK** · 06-02-2012, 02:45 AM

The first thing to do before any of this is to check that your code is as fast as possible - avoid selecting, only work on specific data not whole columns, avoid looping etc.