Here is that same UserForm opened on a Mac. The text might seem a bit small to me now that my eyes are getting older, but it’s still perfectly legible. The result is that without applying any correction, UserForms that come out just right in Windows are only 75% as large on the Mac, making them difficult to read.įor example, here is a UserForm designed in Windows, opened in Windows. Confusing the issue is that VBA in Windows uses points as the measurement unit for designing UserForms, while VBA on the Mac uses pixels. In Windows, screen resolution is 72 dpi (dots per inch) and each dot represents a “point”, while pixels are still 96 per inch. On the Mac, it’s 96 dpi, where each dot represents a pixel. One of the most noticeable is related to the difference in screen resolution between the two platforms. There are many annoyances when designing a VBA project to run on both Windows and Mac computers.
