Excel/VBA running in different computers and MAC

[hanif]

Hi All,

I have created an excell sheet that contains loads of macros and vbs codings (including userforms). It is working fine on my computer (windows 7) and and tried on some other computers and worked just fine (windows 7 and 10) but the problem, it does not work on MAC and also tried in one computer with windows 10 and the screen was zoomed in and expanded. Any idea what is the poblem?

Thanks

[romperstomper]

There isn't 100% compatibility between Mac VBA (any version) and Windows VBA. Unfortunately there are far too many differences to list. If you're going to develop for Mac, you really need a Mac to test on.

[hanif]

Thanks rorya! Any idea why the excel sheet was zoomed in when was tested on a computer with windows? I have tested in 6 different computers (all windows) 4 were fine but on 2 of them it was zoomed in and some macro buttons were out of the screen.

Cheers

[romperstomper]

I'd guess different screen resolutions?

[hanif]

I thought so, I was wandering is there any solution to adopt the excel with the screen resolution. It can be done when I develop a GUI in other software such as MATLAB but can't see an option in excel.

[romperstomper]

It is possible to zoom to a specific range, or you can simply design for the lowest resolution you need it to work on.