You could always use a Locked TextBox (make the caption say "Pending..." or
whatever else you want; and you can add text/background coloring if you want
to also) that has been placed on top of all the other controls (execute the
control's ZOrder method to do this)... start it off invisible, make it
visible just before you start your lengthy process add make it invisible
again afterwards.

--
Rick (MVP - Excel)


"Lemi" wrote in message
...
Excel 2007 & Windows XP pro
Some of the sub-operations in my UserForm take longer time than the others
and I want to display an info message something like "Processing..." or
"Refreshing..." during the process.
This message should not have any buttons and expect a user response. It is
supposed appear during the process without interrupting it and disappear
when process is over. Excel's MsgBox function has always a button waiting
for a response from the User.
I have come accross in the MS Knowledgebase "Call the Windows API function
MessageBox()" but I couldn't understand how. Also I am not sure if it is
relevant to my case. Can anyone help me how to solve this please?

Regards,
Lemi