Forum Discussion
Mac OS UserForm Alternative
JimGMac I tested the code in the link you posted but it did not work. I get an error that variable showform is not declared.
Still looking for a solution.
You can generate user forms via code. Instructions and example code are given in the link below. In the Visual Basic Editor (VBE) 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
Here's more example code
- To get this to work you also have to go to "Excel>Preferences>Secutity>", under "Developer Macro Setting", tick "Trust access to the VBA project object model".
Hello
after following the. instructions I receive this message error :
For N = 1 To ActiveWorkbook.VBProject.VBComponents.Count.
unfortunately I don't get any knowledges in VBA or computer language.
could you please help me.
for my project, i m looking for 2 things :
create an user form or access to the option formular as tool on my ribbon
michaelmich66 Did you remember to "Trust access to the VBA project object module" in Excel Preferences/Security/Developer Macro Settings?
- Microsoft Visual Basic for Applications Extensibility 5.3
