How to tell what is using ActiveX and what isn't

[brettball848]

I just created a vba project for my boss, some of the people that use it have mac's though and I just found out this issue of activex working for windows, but then making the project not work for a Mac. My first question is how do I figure out what controls and codes in my forms use activex and which ones are ok to keep in? Then I need to figure out how to make sure when I put in a control or code its not active x. Any help would be greatly appreciated as I'm having a lot of trouble understanding how to overhaul this program to work for both Windows and Mac.

[Izandol]

If the controls are on userforms, they must be from the Forms library. If you use controls that are not in the toolbox, it is likely they will not work. CreateObject/GetObject I think will not work in code.

Further, there are many small differences between Mac and Windows VBA and therefore you must really test with both.

[brettball848]

Thank you, that was much more helpful than anything I've been able to find searching the internet for hours for answers.

[Izandol]

I think this will be a helpful page for you: http://www.rondebruin.nl/mac.htm

[brettball848]

Thank you so much, that's perfect!

[Richard Buttrey]

If the controls are on userforms, they must be from the Forms library. If you use controls that are not in the toolbox, it is likely they will not work.

Further, there are many small differences between Mac and Windows VBA and therefore you must really test with both.

I concur. In fact it's even simpler than that. Excel for Mac doesn't do Activex Controls. No ifs or buts.
I've lost count of the number of times I've been asked to check systems that clients complain aren't working, only to establish eventually that what started out as a Windows only app have been passed on to Mac users. Now it's usually the first question I ask.