Excel VBA menu bar doesn't appear

Question

Hi, I'm trying to create a data entry form using Excel VBA on Mac. The problem I'm facing is that the menu bar to insert new UserForm doesn't appear as you can see in the image. Any solution plz?

Answer 1

User Forms aren't supported in Excel for the Mac. That's PC( i.e. Windows) only.

Answer 2

Your screenshots just show the Excel about box.

VBA is for macros. Macros are a security risk and are disabled in Office apps. To enable macros you have to do several things. First ensure you have macros enabled in Office following the steps given here.

Secondly, in order to use macros the file must be saved as a macro-enabled file. On Windows that means it is saved as an .xlsm file. You must explicitly save it with macros enabled.

Finally you may need to enable the Developer command bar following the steps given here.

Answer 3

Hi @alwjeeh 77

Here is a similar thread: Creating user forms in excel 365 on Macbook

You can generate user forms via code.

Hope the information could be helpful to you.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---