+ Reply to Thread
Results 1 to 2 of 2

interactive macro

  1. #1
    Registered User
    Join Date
    12-20-2004
    Posts
    29

    interactive macro

    hi all,

    is it possible to make such a macro;

    macro starts, stops(or delays) in between, while the macro stops, the user can look at the sheet, scroll up and down, right or left on the sheet, then when the user hits a key, the macro starts again from the point it stopped, and resumes.
    I used application.wait command, with a time period, but what I didnt like there is that you can not scroll on the sheet when the macro waits, the view is frozen, and that the restart is out of the control of the user.

  2. #2
    Forum Contributor
    Join Date
    11-29-2003
    Posts
    1,203
    The short answer is ... no, you can't.

    The more complete answer is ... of course you can, but it takes some ingenuity.

    What I usually do is to write the first part of the macro .... the last thing this macro does is draw a "click here to resume" button on the sheet. The user can then scroll around, make changes, whatever. When they click the button to resume, it fires off the next part of the routine. The first thing the next part does is kill the button.

    For this type of button, I suggest that you do NOT use an ActiveX control button. Instead, simply use a drawing object with text in it and a macro attached to it. You can use the macro recorder to do all of this. To attach the macro to the drawing object, right click on the object select "Assign macro" from the context menu.

    Sometimes, I create two buttons. One is a large box that covers most of the screen that contains instructions. When the user clicks this large box, it disappears and the smaller "click here to resume" button appears. Caution: you are limited in the amount of text you can put in one of these boxes, so be judicious.

    - Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1