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
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 29, 2023

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

Resources