Posted to microsoft.public.excel.programming

external usenet poster

Posts: 22

Userforms fill screen whatever resolution

Hi,

I am designing a system that I want to look like it is not an Excel
spreadsheet. I would therefore like the UserForms to fill the screen. I can
do this manually but if somebody else has a different screen resolution it
doesn't fit right.

Is there a way of doing this automatically?
Can you use an if to determine screen resolution?

Thanks in advance for any help you can offer.
JohnP

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to get the screen resolution in VBA	Stefan Mueller[_2_]	Excel Programming	2	August 28th 07 10:21 AM
Screen Resolution	Jason Zischke	Excel Programming	2	February 15th 06 05:36 AM
Screen Resolution	Ronbo	Excel Programming	2	January 17th 05 08:45 PM
Screen resolution	Arkimediz	Excel Programming	3	April 1st 04 05:23 PM
VBA code to make CUSTOM VIEW fill ANY RESOLUTION SCREEN	www.ttdown.com	Excel Programming	2	February 24th 04 03:56 PM

All times are GMT +1. The time now is 06:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us