Pausing a procedure

  • Thread starter Thread starter rob nobel
  • Start date Start date
R

rob nobel

I would like to have a procedure present a message (like a MsgBox), to
direct the user to do some tasks. When those tasks have been completed, I
need the procedure to continue with the rest of the code probably by
clicking a button that says "continue". How can that be accomplished?
Rob
 
Use two different procedures.

At the end of the first, give the instructions to start the other macro when
they're done doing what their supposed to do.
 
Thanks Dave, but I might need to give some more info to help explain what I
need.
(I've changed the MsgBox to a Userform as I don't thingk the MsgBox has
enough variations to do what I need.)
1. The macro initually filters a whole bunch of rows.
2. At this point I have a UserForm advising the user to do some stuff, so I
need to be able to leave the UserForm to allow the user to do that stuff
without closing the box as
3. I then want the user to click a "Continue" button on the UserForm to
proceed with another step.
At this point I can't seem to do anything whilst that form is open.
Rob
 
You can show the userform like:
UserForm1.Show vbModeless
(if you're using xl2k or higher)

It'll stay visible and you can do stuff to the worksheet while it's not doing
any work.

You may want to consider using a custom toolbar. Just have it float above the
worksheet--give it some nice tooltips/captions and make sure your users know how
it works.

A floating toolbar would work in xl97, too.
 
Thanks again Dave. The "vbModeless" clue is what I was initually after, but
your further suggestion I will give further consideration.
Rob
 
Back
Top