Forum Discussion

Anthgrim's avatar
Anthgrim
Copper Contributor
Apr 20, 2021

Mac OS UserForm Alternative

I'm looking for an alternative add-ins to create user forms in VBA for Mac, since the Microsoft team removed it from the recent versions for Mac OS.   Do you guys have any suggestions?  
Macros and VBA
pcsrvc's avatar
pcsrvc
Copper Contributor
Jul 08, 2022

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.

 

JimGMac's avatar
JimGMac
MVP
Jul 09, 2022

pcsrvc 

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

VBA Express : Excel - Programmatically Add a UserForm

  • Andrew_Duncan54's avatar
    Andrew_Duncan54
    Brass Contributor
    Jun 07, 2024
    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".
  • michaelmich66's avatar
    michaelmich66
    Copper Contributor
    Oct 20, 2023

    JimGMac 

     

    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

    • Jonathan_Hardis's avatar
      Jonathan_Hardis
      Copper Contributor
      Dec 28, 2023

      michaelmich66 Did you remember to "Trust access to the VBA project object module" in Excel Preferences/Security/Developer Macro Settings?

Resources