Excel Userforms MAC

[Gabochen]

Hello everyone,

I am using Office Excel on a Windows PC at work but at home i have a MAC. I really had a hard time finding all the VBA stuff on the mac. Here`s my question:

How can I add Active X Userforms on my sheet (so that i can doubleclick them and the programm opens the code automatically)? If this is not possible, how can i add a commandbutton on my excel sheet, which opens up a userform if i use the normal code " Load Userform" and then "Userform.Show" on the commandbutton?

Would be great if you could help me! Thanky you in advance!

Greetings

Gabochen

[Izandol]

You may not use activeX with Mac. MSForms control on userform is ok but it will not work on worksheet. You must use Form control on worksheet and assign macro to open userform.

[Kyle123]

I reckon they should do that on windows too....

[Izandol]

ActiveX do sometimes work better but do have, we all know, problems. I do not think they will fix this but perhaps will replace VBA anyway and activeX will have no use then.