Feedback by UserVoice

 

How can we improve Excel for Mac?

← Excel for Mac

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)

1,130 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

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]

274 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Jeroen van Gennip commented  ·   ·  Flag as inappropriate

    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.

  • Fedele commented  ·   ·  Flag as inappropriate

    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.

  • Jay commented  ·   ·  Flag as inappropriate

    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.

  • Jay commented  ·   ·  Flag as inappropriate

    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?

  • Fedele commented  ·   ·  Flag as inappropriate

    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.
    Grazie.

  • Fedele commented  ·   ·  Flag as inappropriate

    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.

  • Jordan Joseph commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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

  • Anonymous commented  ·   ·  Flag as inappropriate

    @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.

  • Will commented  ·   ·  Flag as inappropriate

    Hi Troll,

    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.

  • Crigou commented  ·   ·  Flag as inappropriate

    Hi anonyme.

    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.

    Regards.

  • Flagstaff Dave commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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 ...

  • Hacene commented  ·   ·  Flag as inappropriate

    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!

← Previous 1 3 4 5 … 13 14

Excel for Mac: Macros and Add-ins

Categories

Feedback and Knowledge Base

(thinking…)