Share via

Userform create with vba excel

joep kint 20 Reputation points
2025-02-01T16:04:12.8266667+00:00

In my excel VBA project overview, the userform option is missing in the insert menu option. Only module and class module are shown.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,163 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,780 questions
Accepted answer
  1. Viorel 119.9K Reputation points
    2025-02-01T20:13:10.1633333+00:00

    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).

    2 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 14,655 Reputation points Microsoft Vendor
    2025-02-03T05:58:09.7966667+00:00

    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.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.