Share via

User Form in VBA for Excel in Office 365 for MAC

Anonymous
2019-11-23T17:22:07+00:00

I am attempting to build a User Form in VBA for Excel with MS Office 365 for MAC.  When I open the Developer tab, click on Visual Basic, and then go to the Insert menu, my only option is to add a module or class module.  How do I add a User Form??

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Jim G 133.9K Reputation points MVP Volunteer Moderator
    2019-11-23T17:30:27+00:00

    Hi

    Unfortunately, you can't make one in Office for Mac unless you do it programmatically, which is not practical for most programmers.

    All you can do is join the hundreds of others who want this functionality by voting for this feature request and adding your voice to the groundswell.

    Enable VBA Support for creating and editing UserForms (not the Data Form)

    54 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2019-11-23T18:48:07+00:00

    Thank you so much Jim.  Thought I was losing my mind for a moment when I couldn't find the option to create one.

    11 people found this answer helpful.
    0 comments