Share via

Dont' see the UserForm in Visual Basic editor

Anonymous
2018-08-24T15:38:19+00:00

I just installed the Office 365 home pack on my Mac and I am learning the Excel sheet. While working on a sheet I needed to work on Visual Basic editor but I don't find the User Form, Usually it was present in earlier versions.

While searching I found that it is a missing and Microsoft is working on it. But, still I am not satisfied with this answer. Tell me where is that command, Where I can get that User Form in my Excel( Visual Basic editor)?

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

Anonymous
2018-08-24T15:46:21+00:00

This post may help you manually add the user form as there is no command for Mac yet to add it in.

https://answers.microsoft.com/en-us/msoffice/fo...

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2021-09-02T02:11:55+00:00

    I have an update.

    Be sure you have updated to Excel version 16.52 or newer

    It appears that you can now generate user forms via code. Instructions and example code are given in the link below. 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

    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

    Was this answer helpful?

    0 comments