VBA - Load a Form from a Sub but carry on the rest of the Sub Code whilst the Form is still displayed RRS feed

  • Question

  • Hi all, I have some code that calls a number of  subs, it also calls a form to be displayed. What I am having a problem with though is that when the Form is displayed, it stops running the rest of the code until the form is closed. Is there a Way which I can display the form, but carry on with the rest of the code?



    Sub Complete()
    Call Export
    Load Change_Form
    Call Print
    Call Remove_Stock
    Call Reset
    End Sub 

    Tuesday, February 7, 2012 1:46 PM


  • Use

        Change_Form.Show False

    to show the form "modeless" and to let code execution continue.

    Regards, Hans Vogelaar

    • Marked as answer by t0m46 Tuesday, February 7, 2012 4:35 PM
    Tuesday, February 7, 2012 1:59 PM