Navigate worksheet while waiting for user input?

[John Keith]

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
(e-mail address removed)

 

[Ken Warthen]

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]

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
(e-mail address removed)