This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 56.00000000000001%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
In my excel VBA project overview, the userform option is missing in the insert menu option. Only module and class module are shown.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
An object-oriented programming language developed by Microsoft that can be used in .NET.
On a mac.
I have now understood that userforms are not supported on a Mac.
Very disappointing....
Answer accepted by question author
Did you perform experiments with another new VBA project? What Excel are you using? (It seems that Excel for Mac has a different vision of User Forms).
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Hi @joep kint
Sorry, after Office 2016 for Mac, Excel for Mac does not fully support creating UserForms in VBA, which is why you’re not seeing the option to insert a UserForm in the VBA editor.
Microsoft currently has no plans to restore this feature. The similar feedback thread "Enable VBA Support for creating and editing UserForms (not the Data Form)" is marked as “Not right now”.
Maybe you could consider switching to Excel for Windows.
Thanks for your understanding.
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.
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