Video modes

As you probably know, users' video displays vary widely. A video resolution of 1024 x 768 is most common, but many systems are set up with an 800 x 600 display. And higher resolution displays are becoming increasingly common. Just because you have a super-high resolution monitor, you can't assume that everyone else does.

I discuss compatibility issues in Chapter 26.

I briefly discuss language issues in Chapter 26.

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 uses 1024 x 768 mode, users with a 1024 x 768 display may not be able to see all the input screen without scrolling. 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, there's no way to automatically scale things so that they look the same regardless of the display resolution. In some cases, you can zoom the worksheet (using View ^ Zoom), but doing so may be difficult to do reliably. Unless you're certain of the video resolution that the users of your application will be using, it's important that you design your application by using the lowest common denominator— 800 x 600 mode.

As you will learn later in the book (see Chapter 10), it's possible to 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.



Understanding Visual Basic

for Applications


Introducing Visual Basic for Applications


VBA Programming Fundamentals


Working with VBA Sub Procedures


Creating Function Procedures


VBA Programming Examples and Techniques

Chapter 7

0 0

Post a comment