Feedback by UserVoice

Ian

My feedback

  1. 758 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    194 comments  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    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]

    Ian commented  · 

    In response to Crigou - yes, Libreoffice does implement equivalent UserForms in its macro language. I have converted all my applications and abandoned Excel for Mac. You can use Python and other languages as well as Basic too.

    Ian commented  · 

    I gave up and converted all my macro-enabled spreadsheets to LibreOffice. A bit of work to learn the new interface, but it all works, including the equivalent of Userforms, and its all cross-platform - Windows, Mac and Linux. And its free!

    Ian M

    Ian commented  · 

    For Roman and others looking for alternatives - LibreOffice Basic macros can do almost everything VBA does, and can run Python and JavaScript as well - but there is a learning curve. I have ported an Excel Spreadsheet with quite a complex set of macros to LibreOffice Calc, but you have to rewrite all the user interface calls. And yes, it does do Dialogs, the LibreOffice name for the Userform. Should work in Linux as well as Mac/Windows, but not tested that yet.

    Ian supported this idea  · 

Feedback and Knowledge Base