VBA forms and coding for the MAC in Excel

Question

I operate on a MAC computer with Office 365. The Excel version on the MAC does not let me work in building a form and then code the form. Will this change in the future version of Excel for the MAC?

In windows I can go into the developer in Excel, develop my forms and then write the code I need for the form to function. I am now working on a MAC computer with Office 365 and the Excel version in this program does not allow me to develop the forms then write the VBA code.

Am I missing something?

Answer 1

Hi Robert,

Thanks for posting in the community.

For now, I am afraid there is no out-of-box feature to insert form in Excel for Mac. To view all the latest updates about Office, you can go to Microsoft 365 roadmap and search the feature. As you mentioned, you can insert the form in Excel for Windows.

Based on the situation, I would like to suggest you send feedback to Microsoft via clicking the Help menu and choose Give Feedback. It’s the platform for us to hear your voice and improve our products.

Appreciate your understanding and patience.

Regards,

George

Answer 2

Thank you I will sent them the request. I am so disappointed in Microsoft for leaving this element out of Excel for the Mac.

Answer 3

Be sure you have updated to Excel version 16.53 or newer

You can now generate user forms via code. Instructions and example code are given in the link below. In the Visual Basic Editor (VBE) be sure to use the Tools menu > References and set these References before running the example code:

• Microsoft Visual Basic for Applications Extensibility 5.3
  Microsoft Forms 2.0 Object Library

Here's a screenshot of the settings I use. Making and editing userforms programmatically is working just fine.

Here's example code:

VBA Express : Excel - Programmatically Add a UserForm

This should get you started. I think you can now use code to add, remove and modify the userform and its controls. Please give this a try and reply whether or not this works for you.

Thanks

Answer 4

Hi again,

Right now the VBE is missing the ability to show the userform in edit mode, and as a consequence display the properties of whatever is selected.

I think you can do all manipulations of forms and controls via code at this time. I'm planning to build myself a little library of code snippets for various actions with forms and form controls.