Vba - Excel Mac - UserForm - Stack Overflow

1. 1. Home
   2. Questions
   3. Tags
   4. Users
   5. Companies
   6. Labs
   7. Jobs
   8. Discussions
   9. Collectives

   10. Communities for your favorite technologies. Explore all Collectives

2. Teams

   Ask questions, find answers and collaborate at work with Stack Overflow for Teams.

   Try Teams for free Explore Teams
3. Teams

4. Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

Get early access and see previews of new features.

Learn more about Labs Excel Mac - UserForm Ask Question Asked 2 years, 10 months ago Modified 2 years, 10 months ago Viewed 3k times 0

I am so close to being able to fully use the UserForm on Mac Excel.

In the VB Editor I needed to go to Tools->References and Enable: Microsoft Visual Basic for Applications Extensibility 5.3

Now if I add the following code in a sub and run the sub:

set objForm = ThisWorkbook.VBProject.VBComponents.Add(vbext_ct_MSForm)

It actually works! A form control gets added in the project browser, I see the form and have the toolbox available and all properties. But its one and done, I can't figure out how to go back and edit the form once I close that window. I can edit the code but never get the designer window to pop up again.

I feel like its a hack but there's likely a different line of code that I can put in its own sub to trick VB Editor to open that designer window back up again.

Any ideas?

• excel
• vba
• macos

Share Improve this question Follow edited Feb 22, 2022 at 3:08 braX 11.7k55 gold badges2222 silver badges3737 bronze badges asked Feb 22, 2022 at 3:05 Peter MusserPeter Musser 111 silver badge33 bronze badges 1

• IME your best bet is to develop your forms on Windows, and only make minor tweaks and adjustments on a Mac. Depending on the version it's possible your IDE doesn't have a designer for such forms, which leaves you with only 100% dynamic forms & controls if you can't develop them on a Windows machine. Good luck! – Mathieu Guindon Commented Feb 22, 2022 at 5:49

Add a comment | Related questions 1 Excel Spreadsheet Convert to UserForm VBA Problem 1 How to bring the userform in the excel sheet? 0 Userform to populate worksheet Related questions 1 Excel Spreadsheet Convert to UserForm VBA Problem 1 How to bring the userform in the excel sheet? 0 Userform to populate worksheet 4 Excel VBA Userform Controls 0 Excel VBA user form 0 Userform not functioning properly 0 Creating UserForm on VBA 6 Userform with Excel 2018 for MacOS 1 how to create an excel built in userform 3 Option to insert userform in Excel VBA is not displayed in Mac version Load 7 more related questions Show fewer related questions

0

Sorted by: Reset to default Highest score (default) Trending (recent votes count more) Date modified (newest first) Date created (oldest first)

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question. Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.
• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Draft saved Draft discarded

Sign up or log in

Sign up using Google Sign up using Email and Password Submit

Post as a guest

Name Email

Required, but never shown

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged

• excel
• vba
• macos

or ask your own question.

• The Overflow Blog
• Why do developers love clean code but hate writing documentation?
• This developer tool is 40 years old: can it be improved?
• Featured on Meta
• The December 2024 Community Asks Sprint has been moved to March 2025 (and...
• Stack Overflow Jobs is expanding to more countries

Hot Network Questions

• Reference request concerning Frege on truth?
• Is it Appropriate to Request a Seminar Invitation from a University Department as a research Student?
• Best Practices for Managing Open-Source Vulnerabilities in Enterprise Deployments
• Merits of `cd && pwd` versus `dirname`
• Odds of hitting a star with a laser shone in a random direction
• Why does the US believe that Pakistan's missile program is now directed against it?
• Why does a rod move faster when struck at the center rather than the edge, despite Newton's second law indicating the same acceleration?"
• Smallest arcseconds viewable by perfect conditions (i.e. space-based telescope)
• What does "No Reachable Authority at delegation" mean? (aka NS record not returned by the DNS)
• Misunderstanding a code
• What is the I in "I think therefore I am"?
• Answering student's question that is already in the upcoming exam
• Permanent night on a portion of a planet
• What do "messy" weapons do, exactly?
• Can I bring candles on an European flight?
• More efficient way to color-code cycle permutation list
• Makefile for a tiny C++ project
• Why does ctldl.windowsupdate.com not use (valid) TLS?
• How feasible would it be to "kill" the Sun by using blood?
• Why were my lead-acid batteries destroyed after operating them in parallel?
• Why don't the Bene Gesserit retaliate against Vladimir Harkonnen for trying to kill Jessica and Paul?
• Why does a country like Singapore have a lower gini coefficient than France despite France having higher income/wealth taxes?
• Jingle bells, Christmas sells!
• ping from script launched by cron

more hot questions Question feed Subscribe to RSS Question feed

To subscribe to this RSS feed, copy and paste this URL into your RSS reader.

lang-vb