Feedback by UserVoice

Steve Van Dellen

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]

    Steve Van Dellen commented  · 

    On July 23 I posted a comment that, if you opened a workbook with UserForms created with Excel for Windows, the form and controls seemed to work just as they did with Windows and you could edit the UserForm with VBA, again, just as you could with Windows. In that post, I said you couldn't create a new UserForm from scratch with Excel for Mac so you had to have Excel for Windows to get started. It turns out that VBA in Excel for Mac CAN create a new UserForm. https://stackoverflow.com/questions/11519345/creating-form-programmatically-in-the-module-using-vba describes how. I think that code was developed for Excel for Windows but I just copied it into a VBA Module in Excel for Mac and it worked. I haven't done any more with it yet but I don't see why a person can't create any sort of UserForm they like now. Adding Controls and setting all the attributes with code is surely painful compared to doing it visually with the VBE but it does give us a way go forward without waiting for Microsoft.

    p.s. Note that you MUST add "Microsoft Visual Basic for Applications Extensions" to the References for the workbook or the code won't compile.

    Steve Van Dellen commented  · 

    If you create a workbook with a UserForm with Excel for windows and then open the workbook with Excel for Mac, it displays the UserForm, the controls all seem to work just like they do with Windows, and you can edit the code in the VBE. The only things missing are the visual editor and the ToolBox so you can't create a new UserForm, change the layout or add/delete Controls. I wouldn't have guessed these were hard to port or re-implement for the Mac.

    Steve Van Dellen supported this idea  · 

Feedback and Knowledge Base