Enable VBA Support for creating and editing UserForms (not the Data Form)
In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.
(March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)
Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.
I updated the title and description for this one and we’ll continue to monitor for comments and votes.
Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality
Steve K [MS Excel]
Let's hope that the future Excel version running on the ARM chip will be better:
Jeroen van Gennip commented
Missing the form (both) options in Excel 365 for Mac.
This definitely is a big miss.
As a professional, i use forms regularly to simplify the use for my colleagues.
Attendiamo intervento necessario. Mi sono iscritto in prova per 30gg. E dovrò decidere entro 30gg se rinnovare l’iscrizione definitivamente o non rinnovarlo. Se queste sono le premesse al momento ... non sono molto soddisfatto.... del servizio Microsoft.
I did not mean to vote for the Data Form. I voted exactly for what I wanted. The fact that I have an Excel macro file that I can edit the UserForms in Excel Windows but can ONLY access the form's code in the Mac version is mind-numbingly dumb. Thank you for updating the title.
Quando aggiornate la funzionalità ? Grazie
Ridiculous that one can no longer edit a Userform within an MS Excel VBA project. Whoever made the decision to remove a critical feature of VBA needs to actually try and use the product?
dai commenti ho notato che da diverso tempo viene richiesta l'integrazione necessaria per poter lavorare seriamente con excel per Mac, ma non è ancora stata presa in seria considerazione. Come mai esiste questo strumento per i suggerimenti e non intervenite tempestivamente alle richieste dei vostri clienti? Così si rischia di demotivare i vostri clienti.
sarebbe molto utile riattivare la possibilità di UserForm richiesto da molti clienti. Senza questa funzionalità non è possibile ottenere delle maschere di caricamento dati.
Grazie per il ripristino.
sarebbe opportuno e utile riattivare tale funzionalità (USERFOR)
To your fundamental and interesting question (why this situation with VBA on Mac Excel), deep explanations are given by Jim Gordon here:
Regards and good reading.
Jordan Joseph commented
Man, how is this not included yet. It's been years that people have been asking to have this essential functionality incorporated into the Mac version of Excel. I'm starting to think it's purposely being pushed aside to discourage Mac users.
por favor ya activen las funciones de excel windows para Mac... hasta cuando tanto enrollo por usar otro sistema operativo, hacen perder tiempo, dinero y esfuerzo en vano
Bo Wallsten commented
Make it simple to program, please
@will. Thanks man, I know this side-chat is not directly relevant to the thread, and notwithstanding that you sort of give Crigou the attention he is after each time you respond, I always have a great LOL at the way you put him in his place. Priceless ! :-) So thanks again.
Yes you, Crigou. Why? Why do you seek companionship here? Nobody here cares what you think... You’re not a moderator. You’re not a Microsoft employee.
This is not a dating website. You’re not going to strike up an interesting debate here that leads to a lasting relationship. Stop bating folks here and go for a walk. Buy a coffee. Talk to a real person. Stop hanging out on forums trolling for recognition.
If that doesn’t work, talk to a therapist. Read a self-help book.
When you are writing to Microsoft : « ... sino tendré que cambiarme de osx a windows ... « you are just offering them what they expect : a future new Windows user.
Flagstaff Dave commented
I'm taking an online training to sharpen my skills in Excel which I have been using before Windows existed. I have to say I am very disappointed that at this point in history, the Mac version lacks feature parity with the Windows version, and in some very important ways.
So far what has popped out to me are:
1) 1 item saved to the clipboard vs. 24 in Windows
2) No UserForm
3) Recommended Pivot Tables in Mac is just Pivot Tables.
4) No icons for custom items on the Ribbon, like Macros
It can be said that Word and Excel ushered in Windows at Apple's expense. The user base they cultivated on the Mac allowed those programs to overthrow WordPerfect and Lotus 1-2-3. MS ought to make sure Mac users are not hobbled when it comes to using Excel.
esa función de formularios y ademas la macro para enviar correos en outlook también no funciona .......agregarla por favor ......sino tendré que cambiarme de osx a windows ...
I was very disappointed when didn't find the UserForm tools.
Microsoft should really make sure that MS Office macros using library and userforms should be available on all computers running any version of Office (Mac or MS). VB and particularly VBA is a much clearer language to write code with than most others (html, js, c#). Some of us have been working with VBA for more than 20 years and find it frustrating not to be able to collaborate using standard macros because of different platforms. This is hampering productivity.
At least MS should provide a code converter to ensure that macros (including references) written under Windows are fully functional under Mac!