Navigate worksheet while waiting for user input?

  • Thread starter Thread starter John Keith
  • Start date Start date
J

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)
 
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,

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.
Click to expand...

Ken,

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


John Keith
(e-mail address removed)
 
Back
Top