Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mouse is not letting go of a cell | Excel Discussion (Misc queries) | |||
AUTHORITY OF VARYING RIGHTS | Excel Discussion (Misc queries) | |||
edit cells only with authority | Excel Discussion (Misc queries) | |||
Limit User scrolling | Excel Programming | |||
Not letting me import XML data | Excel Worksheet Functions |