Screen Resolution

Hi,

Is there a way to get the screen resolution in VBA?

thanks!

Hello yonyon7,

Here is another approach. This uses the Windows Management Instrumentation (WMI) scripting interface. This method can easily allows you access many other monitor settings than just screen size and the monitor name. Place this code in a Standard VBA module.

Please Login or Register  to view this content.

Run ShowScreenSize from Excel by typing ALT + F8. Double click ShowScreenSize in the list.

Sincerely,
Leith Ross