Navigate worksheet while waiting for user input?
 

Is it possible to allow a user to navigate around a worksheet while
waiting for a user input to a msgbox?

For instance, while waiting for a response to the following line of
code is there a way to allow the user to peruse the worksheet (mostly
scroll left and right to view the line):

answer = MsgBox("Do you want to delete this row?", vbYesNo)


John Keith

Navigate worksheet while waiting for user input?
 

John,

The Excel message dialog boxes are modal and will not allow you to navigate
or do anything else until a response is processed. You could create a
userform that mimics an Excel dialog box but is not set to modal to get
around the limitation.

Ken

"John Keith" wrote:

Is it possible to allow a user to navigate around a worksheet while
waiting for a user input to a msgbox?

For instance, while waiting for a response to the following line of
code is there a way to allow the user to peruse the worksheet (mostly
scroll left and right to view the line):

answer = MsgBox("Do you want to delete this row?", vbYesNo)


John Keith

Navigate worksheet while waiting for user input?
 

On Fri, 11 Sep 2009 10:19:01 -0700, Ken Warthen
wrote:

John,

The Excel message dialog boxes are modal and will not allow you to navigate
or do anything else until a response is processed. You could create a
userform that mimics an Excel dialog box but is not set to modal to get
around the limitation.

Ken,

Thanks, I guess it's time to learn a new trick.


John Keith