Letting user have temporary scrolling authority
 

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

Letting user have temporary scrolling authority
 

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



ArthurJ wrote:

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

--

Dave Peterson

Letting user have temporary scrolling authority
 

And then show that userform as non-modal.

UserForm1.Show False

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

UserForm1.Show vbModeless

--
Rick (MVP - Excel)

Letting user have temporary scrolling authority
 

Doh!

I agree.

Thanks for the correction, Rick.

Rick Rothstein wrote:

And then show that userform as non-modal.

UserForm1.Show False

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

UserForm1.Show vbModeless

--
Rick (MVP - Excel)

--

Dave Peterson