Since I am not any great Visual Basic for Applications (VBA) programmer
I am probably missing something very simple here. I searched for an
answer in this group and some items that sound related don't seem to
apply to my problem.

So here it is...

I have a VBA program in an Excel spreadsheet. This program is creating
contacts in an Outlook folder and also putting some data in a worksheet
as it goes along. This program works great.

The little issue is under some conditions the program needs to issue a
message for the person to acknowledge (OK or CANCEL). The message box
does get generated but it does NOT display directly. The Outlook
window is the one that is opened at the time and if you don't notice it
the "Excel" on the task-bar is "blinking". You have to click on the
Excel application to get it to open and then you have the "msgbox"
being displayed.

I have tried to "activate" the Excel application but even in that case
the "msgbox"is not displayed unless I click on Excel.

So what is the trick I am missing? How do I get that "msgbox" to
display so my users don't have to "look for it"?

Thanks in advance for you help.

Bernie