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
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

D_Mon

New Member
Joined
Feb 9, 2019
Messages
6
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.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,463
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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...
 

Watch MrExcel Video

Forum statistics

Threads
1,127,441
Messages
5,624,798
Members
416,054
Latest member
Ariel2219

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
Top