pause

[geebee]

hi,

I have the following:

'//-------------------------------------------------
'-Make sure total lines titled "totals" in sheet "options" are all equal
'//-------------------------------------------------
Sheets("options").Activate
Sheets("options").Select
MsgBox "Make sure total lines titled 'totals' in sheet optionsare all equal"

I would like for the code to be able to pause to allow the user to actually
performs what the messagebox is instructing, then for the code to continue
execution when the user clicks the messagebox or something. How can I do
this?

Thanks in advance,
geebee

 

[Tom Ogilvy]

use a modeless Userform to display your message.

Userform1.show vbModeless

 

[geebee]

hi,

Then how do I resume back to the code after the form is closed, without
putting all of the code that follows in the UserForms "contunue button" I
added?

Thanks in advance,
geebee

 

[Tom Ogilvy]

You would have to put a continue button on the userform for the user to
indicate they had finished doing their work on the worksheet.

Lotus has the provision for the code to pause and let the user make changes
on the sheet. Excel doesn't have that capability. so you have to kludge
together a solution if your want to do that.

Without knowing what you are doing, I would have the code check the
condition that needs to be satisfied and if the code couldn't fix it itself,
then warn the user and quit. Tell them to run the procedure again when they
have fixed the sheet.