Long running operations

[Erik Wikström]

Hello

I have an Excel-file that interacts with MATLAB, some of the interactions
can take quite a long time, when that happens a window comes up saying that
"Microsoft Office Excel is waiting for another application to complete an OLE
action. I understand that I should be able to get rid of this window by
setting Application.DisplayAlerts to false during the operation.

However instead I would like to show a model window of my own (without any
buttons or such) with a message like "please wait" and then when the
operation is completed I remove the window. Is that possible?

AFAIK if I use a normal form and run Show() then I will not be able to close
it from the code that created it, that have to be done in code belonging to
the form, is that correct?

 

[Jean-Yves]

Hi Erick,

Follow this structure

Sub StartMacro
userform.show
End sub

Sub userform_Activate
Call main
Unload me
end sub

Sub Main
'do something
End sub

Regards

JY