AnsweredAssumed Answered

How to i get user input then continue using my macro once the user "triggers" the macro to start again?

Question asked by Brady Kallert on Jun 9, 2020
Latest reply on Jun 10, 2020 by Josh Brady

Like • Show 0 Likes0
Comment • 4

Hello,

For some background; My macro creates a curb based on a userform, it then creates drawings based on template files, since the sizes of these curbs vary vastly the drawings need to be fixed manually, after touching up the drafts the macro would ideally continue it's process.

I need some help pausing the macro to allow the user to clean up the drawings and then allow the user to start the macro again by performing an action (ideally saving would be the most intuitive).

Any help would be appreciated.

Thanks.

Artem Taturevych Jun 9, 2020 12:29 PM

Correct Answer

The correct way would be to use events and sync your code. Events will not block the UI thread and you will be able to automatically decide when to continue. Check a second approach from this example: Wait for user selection in document using SOLIDWORKS API

Simpler way is creating Modeless User Form with a button ‘Continue’ so your user will press the button to continue.

Even simpler implementation is using ‘stop’ keyword, but VBA editor will pop up with break on code line and user will need to click F5 or ‘play’ button to continue execution.

See the reply in context

No one else had this question

Outcomes

Artem Taturevych Jun 9, 2020 12:29 PM

Simpler way is creating Modeless User Form with a button ‘Continue’ so your user will press the button to continue.

Even simpler implementation is using ‘stop’ keyword, but VBA editor will pop up with break on code line and user will need to click F5 or ‘play’ button to continue execution.

Actions

Brady Kallert @ Artem Taturevych on Jun 10, 2020 12:41 PM

The modeless was really the game changer for me here.

so i started started by declaring a

public continue as boolean

(above my main sub)

then i created a new userform and showed it via

continue = false

userform.show vbmodeless ' by having it as modeless i was able to access the drawing until i clicked the button

DoEvents

Loop Until continue=True

within userform i had

userformbt_Click()

Continue = True

userform.hide

Actions

Josh Brady @ Brady Kallert on Jun 10, 2020 1:00 PM

Best case is to end your main macro's sub right after calling the modeless form. Then, use the button in the modeless form to call another sub in the main macro with the continuation code.

Actions

Josh Brady Jun 9, 2020 1:37 PM

From your description, I would recommend the Modeless User Form that Artem mentioned above. Once you hand control back over to the user, who knows what they'll do. Maybe they'll save, maybe they won't. Maybe they'll close SW. Or open/switch to a different document. Or just go on break and forget they were in the middle of something. Having the user form still there and visible (it can be quite small to avoid getting in the way), is just a small reminder to the user that they're still in-process, and it also prevents them from accidentally triggering your macro to continue before they were ready. Not sure how long or involved this cleanup is, but I would hate to have a user unable to save their work because it would trigger something to happen that they weren't ready for.

Actions

4 Replies

Artem Taturevych Jun 9, 2020 12:29 PM
Unmark Correct
Correct Answer
The correct way would be to use events and sync your code. Events will not block the UI thread and you will be able to automatically decide when to continue. Check a second approach from this example: Wait for user selection in document using SOLIDWORKS API

Simpler way is creating Modeless User Form with a button ‘Continue’ so your user will press the button to continue.

Even simpler implementation is using ‘stop’ keyword, but VBA editor will pop up with break on code line and user will need to click F5 or ‘play’ button to continue execution.
Like • Show 1 Like1
Actions
- Brady Kallert @ Artem Taturevych on Jun 10, 2020 12:41 PM
  Mark Correct
  Correct Answer
  The modeless was really the game changer for me here.
  so i started started by declaring a
  public continue as boolean
  (above my main sub)
  then i created a new userform and showed it via
  
  continue = false
  userform.show vbmodeless ' by having it as modeless i was able to access the drawing until i clicked the button
  Do
  DoEvents
  Loop Until continue=True
  
  within userform i had
  userformbt_Click()
  Continue = True
  userform.hide
  Like • Show 0 Likes0
  Actions
  - Josh Brady @ Brady Kallert on Jun 10, 2020 1:00 PM
    Mark Correct
    Correct Answer
    Best case is to end your main macro's sub right after calling the modeless form. Then, use the button in the modeless form to call another sub in the main macro with the continuation code.
    Like • Show 0 Likes0
    Actions
Josh Brady Jun 9, 2020 1:37 PM
Mark Correct
Correct Answer
From your description, I would recommend the Modeless User Form that Artem mentioned above. Once you hand control back over to the user, who knows what they'll do. Maybe they'll save, maybe they won't. Maybe they'll close SW. Or open/switch to a different document. Or just go on break and forget they were in the middle of something. Having the user form still there and visible (it can be quite small to avoid getting in the way), is just a small reminder to the user that they're still in-process, and it also prevents them from accidentally triggering your macro to continue before they were ready. Not sure how long or involved this cleanup is, but I would hate to have a user unable to save their work because it would trigger something to happen that they weren't ready for.
Like • Show 0 Likes0
Actions

How to i get user input then continue using my macro once the user "triggers" the macro to start again?

Outcomes

Related Content

Recommended Content