MS Visual Basic USER FORMS

Question

my Excel runs Visual Basic for Applications 7.1.  The Visual Basic Editor shows "MSExcel Object", "Modules", but doesn'show "Forms"

How can I use the USERFORMS?

Answer 1

Hi Madoc,

There is more that you should know before saying goodbye to this topic.

It is easy to add a userform in Office for Mac using code. However, there is something you must do before running the code. Go to Excel > Preferences > Security. You must click the check box Trust access to the VBA project object model.

Once you have established the trust setting, you can run this code to generate a userform:

Sub CreateUserForm()

Dim myForm As Object

Set myForm = ThisWorkbook.VBProject.VBComponents.Add(3)

End Sub

Answer 2

Hi again,

I tried importing an empty userform using File > Import in the VB Editor. That works.

However, I was not successful in using VBA to add controls to the userform. Very bad.

Answer 3

It's so sad when paid support people know so little about the product they are supporting that they know nothing at all about even basic functionality. They try to help, but only cause delay and waste your time.

Office 2016, 2019 and 365 for Mac do not have a UserForm editor. 

I know that you, me, and hundreds of others want this basic functionality. All we can do is vote for feature restoration and comment on the situation here:

Enable VBA Support for creating and editing UserForms (not the Data Form)

You can make and edit userforms in Office for Windows and Office 2011 for Mac (which does not run in Mac OS Catalina). Userforms from OpenOffice or LibreOffice are not compatible with Microsoft Office.

Answer 4

Dear Mr. Caprio,

I thank you very much for your attention, but this is not what I'm looking for.

I can't find the option "Create a Userform" on drop down menus in Excel. It doesn't show on the design menu.

I want to know if Microsoft Office 365 family edition has this feature. If it does, I want to know hoe to use it.

Thanks,

Decimo Mazzocato

Answer 5

Hi, DecimoMazzocato

My name is Phillip, an Independent Advisor trying to help.

In these links you explain how to create forms to your liking.

I hope they serve you

https://support.office.com/en-us/article/create...

https://support.office.com/en-us/article/create...

Regards.

Standard Disclaimer.

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.