EXCEL - Form or Message 1

[OldSkoolSkater]

Hi All,

I have a macro in Excel which runs fine, but it jumps around the screen quite a bit while its running. The user would like me to display a screen over the top of it, with the message of "Processing - Please Wait", while the macro is running.

What is the best way to achieve this?

I looked as userforms, but I can't get it to display over the top of the sheet while the macro is running.

Any help would be appreciated.

 

[Chance1234]

play around with the set focus property of the form
also look at the modal property as well but you will need to put your code into the form

also if it is jumping around the screen when you run add this line of code after you declarations in your code

application.screenupdating = false