View original (French)

VBA-reopen a userform on MAC

LPA92 Posted messages 8 Status Member -  
 Rico -
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 Posted messages 2254 Status Member 339
     
    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
  2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    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
  3. Frenchie83 Posted messages 2254 Status Member 339
     
    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
  4. LPA92 Posted messages 8 Status Member
     
    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
  6. LPA92 Posted messages 8 Status Member
     
    Yes, it only opens the code window.
    0
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      no other idea, sorry.
      You should edit your title and specify on Mac
      eric
      0
    2. LPA92 Posted messages 8 Status Member
       
      Just how do you change the title? I don't see any edit function on the first post.
      0
    3. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      I did it for you.
      0
  7. 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