Building a userform that loads on both MAC and PC ?

Hello guys,
I've tried creating a userform on Excel 2010, and loading it on a mac with Excel for MAC 2011, and I've already run into a few basic problems (userform1.show fails with run time error 80020005). However, if I launch the userform it loads, but it looks terrible (in comparison to the pc version).

Does anybody have a good generic way to launch a userform from an excel button, and have it looks like a normal mac interface ?

this is so frustrating.

Actually, after further testing, and using the immediate window, I was able to determine that In my code I was trying to set the look/feel of the controls on a userform.

However, I had created a Const , but it seems that was what was causing my error. Changed the Const to a Dim, and the userform now loads as expected.

Actually as of Office for Mac 2011, a lot of VBA stuff was put back in (and made to be 80% compatible). The only things that fail are code chunks that call on system level libraries for certain functions.
For example this works perfectly (checks if an text in a textbox matches all correct email patterns) on Windows, fails horribly on OSX (for obvious reasons):

Please Login or Register  to view this content.

hence the reason why I modified it slightly to this:

Please Login or Register  to view this content.

However, a lot of functions work the same on both, the only thing I have discovered is that Mac seems to prefer to not use the ME. object, but prefers the actual object name USERFORM.Control.item("ControlName")

Lastly, the only thing that wasn't done well is the look and feel of a userform. Without modifying the font size/type and background color, the userform tends to have very small font and tiny controls, and be very dark background.

That's what I was working on during this problem.

I'll post my final look/feel code for anybody who wants it for the future.