VBA-reopen a userform on MAC
LPA92
Posted messages
8
Status
Membre
-
Rico -
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:
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 réponses
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
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
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
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
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
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
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:
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:
