View original (French)

VBA-reopen a userform on MAC

LPA92 -  
Hello,

I am new to VBA and I am currently working on using the userform tool (I am on Mac, Office 365).
I can create a userform and modify the code. However, the next day when I go back to modify my userform: I cannot find how to display the starting window with my text and the comboboxes (image below shows a blank userform)... I cannot find a button in Visual Basic to reopen the userform (the code opens fine).

Thank you for your help!

Here is what I wish to reopen:


When I right-click on the userform:

6 answers

  1. Frenchie83
    Good evening,

    Add a button to your file and assign the following macro to it:
    Sub Open_Form
    UserForm1.show
    End Sub

    You can also open your form by positioning yourself on the form's code and clicking on the small green triangle in the Visual Basic toolbar just below "Format"

    Regards
    1
    1. eriiic Contributor
      Hello,

      have you tried double-clicking on the module?
      eric

      By continuously trying, we eventually succeed.
      So the more it fails, the more chances we have that it works. (the Shadoks)
      In addition to the thank you (yes, it can be done!!!), remember to mark it as resolved. Thank you
      1
      1. Frenchie83
        Hello,

        To display the form and be able to modify it, select the small icon in the middle among the 3 in the project window -VbaProject


        Best regards
        1
        1. LPA92 Author
          Hello,

          By creating a button with this macro, the userform window opens, but I cannot modify it.

          I want to reopen it in order to modify it.

          Here is my interface:

          0
          2. LPA92 Author
            Yes, it only opens the code window.
            0
            1. eriiic Contributor
              no other idea, sorry.
              You should edit your title and specify on Mac
              eric
              0
            2. LPA92 Author
              Just how do you change the title? I don't see any edit function on the first post.
              0
            3. eriiic Contributor
              I did it for you.
              0
          3. Rico
            Hello,

            I have exactly the same problem, it's impossible to display my userForm for editing.... does anyone have a solution?

            Thank you.
            0