Excel 2019 mac. Userform not visible in VBA design mode

[Paul149]

I have just upgraded from Excel 2011 to 2019

I have a VBA project that includes 2 user forms.

In 2011 when I double clicked on the form name it opened the form in design mode and let you add command buttons, delete them, position, etc. If you then clicked on one of the items it opened up the code window which you can then write/amend the code

In 2019 when I double click on the form name it opens up the code window immediately … the form itself doesn’t appear. I cannot therefore amend the design of the form

So, my question is … how do I display the form so I can change the design etc.

Thanks

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Option to insert userform in Excel VBA is not displayed in Mac version

I wanted to create a Userform in the Visual Basic editor but that option seems not available (see screenshot). How can I change that?

stackoverflow.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[RoryA]

As mentioned in your thread at SO, that feature STILL hasn't been added to Mac Excel. It's been missing since 2016.

 

[Paul149]

Thank you for your help ... very annoying the feature is missing ... causing me lots of problems ... such is life!