VBA: Display Designer Window

D_Mon

New Member
Joined
Feb 9, 2019
Messages
6
Hello,

I have Excel for Mac 2019 und want to design UserForms in the VB editor.
I can create new UserForms end edit them in the designer window but once the designer window was closed it cannot be reopened.
With right click on the UserForm entry in the Projekt explorer there is no entry to open the object. Double clicking the entry opens the code window. Clicking either of the two icons left besides the folder icon in project explorer also only opens the code window.

In Excel for Mac 2011 the design window can be reopened after closing. Is there a way to do it in Excel for Mac 2019?
I even tried to open the DesignerWindow programmatically:
Code:
ThisWorkbook.VBProject.VBComponents("Userform1").DesignerWindow.Visible = True
This works in Excel 2011 but not 2019.

Am I missing something?
Does anyone have an idea hot reopen the designer window in 2019 version of Excel on Mac?

Greetings
D.Mon
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Thank you for your reply.
I know that in Office for Mac 2016 you could neither insert nor edit UserForms in VB Editor.
In the VB Editor of Office 2019 the "Insert Userform" command was reintroduced.
There is a "View Object" button but it opens the code window.
I can´t believe that there is no way to open the designer window again once it is closed.
 
Upvote 0
You're lucky you can do it at all. Excel with a 365 subscription on Insider Fast doesn't allow inserting userforms, and it's supposed to be more current than 2019. I suspect they put that in by mistake...
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,106
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top