Letting user have temporary scrolling authority

A

ArthurJ

At a critical point in the macro I display a message box asking the user if
everything looks OK. He can choose to continue or stop. If he continues the
macro goes on to perform major surgery to the data table.

The only problem is that when the message box is displayed the user cannot
scroll around the screen to examine all areas of the large data table. Is
there a way to provide this flexibility without leaving the confines of the
original macro?

Thanks,
Art
 
D

Dave Peterson

If you're using xl2k or higher, you could drop the msgbox and build a userform.

And then show that userform as non-modal.

UserForm1.Show False
 
R

Rick Rothstein

And then show that userform as non-modal.
UserForm1.Show False
Click to expand...

More self-documenting would be to use the built-in VB constant...

UserForm1.Show vbModeless
 
D

Dave Peterson

Doh!

I agree.

Thanks for the correction, Rick.

Rick said:
More self-documenting would be to use the built-in VB constant...

UserForm1.Show vbModeless
Click to expand...
 
Top