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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Box Scroll Bars do not appear until you click in the text box 2
A macro to authorize a user to run another macro. 0
Give user option to delete certain Tables with specific words in column 0
Help with code restricting TextBox entry 6
User Form instead of message box to collect data 2
how to add a textbox if user chooses yes in response to msgbox. 0
set default value for unbound cbo from different table than source 0
Temporary tables 5

Top