Microsoft Office Tutorials and References
In Depth Information
Other Development Issues
As you probably know, users’ video displays vary widely. As I write this topic, the most
commonly used video resolution is 1280 x 1024, followed closed by 1024 x 768. Systems with a
resolution of 800 x 600 are becoming much less common, but quite a few are still in use. Higher
resolution displays and even dual displays are becoming increasingly common. Just because you
have a super-high-resolution monitor, you can’t assume that everyone else does.
Video resolution can be a problem if your application relies on specific information being
displayed on a single screen. For example, if you develop an input screen that fills the screen in 1280
x 1024 mode, users with a 1024 x 768 display won’t be able to see the whole input screen without
scrolling or zooming.
Also, it’s important to realize that a restored (that is, not maximized or minimized) workbook is
displayed at its previous window size and position. In the extreme case, it’s possible that a
window saved by using a high-resolution display may be completely off the screen when opened on
a system running in a lower resolution.
Unfortunately, you can’t automatically scale things so that they look the same regardless of the
display resolution. In some cases, you can zoom the worksheet (using the Zoom control in the
status bar), but doing so reliably may be difficult. Unless you’re certain of the video resolution
that the users of your application will use, you should probably design your application so it
works with the lowest common denominator — 800 x 600 or 1024 x 768 mode.
As you discover later in the topic (see Chapter 10), you can determine the user’s video resolution
by using Windows API calls from VBA. In some cases, you may want to programmatically adjust
things depending on the user’s video resolution.