View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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