Yeah, I'll probably do that once I feel like I know enough about how Office uses pixel/point dimensions for different windows. Both Win and Mac are a pain the butt about this, and of course they're not quite the same.Originally Posted by johnske
shades, one thing that might be useful for your forms is the Userform.Zoom property (in Userform_Initialize).
For example, you can use:
[vba]#If Mac then
Userform.Zoom = 120
Userform.Width = Userform.Width *1.2
Userform.Height = Userform.Height *1.2
#end if[/vba]
Doesn't fix everything, but will help make frame captions and combo boxes legible, radio buttons round, and stufff like that. At least gives you a start so that you don't have to change every property in the form. Remember to change Userform.Width and .Height to match, because that's not automatic.