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

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

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