At least three topics here:

When you say Userform, you mean Userform, and not Worksheet, correct?

I will work on that assumption.

A userform can be sized using the .Zoom method. You will need to come up with a relationship between the points width of your intended display resolution.

.Zoom = CInt(Application.Width / 774 * 90)

.Width = Application.Width

.Height = Application.Height

Is what I use to 'full screen' a userform of my current project.

Actually, it just matches the dimensions of Excel's window, at that point in time. So, if it is maximized, the form will be maximized. Whatever the 'footprint' of Excel, the userform will match it.

774 is the approximate point value of 1024 by 768 display resolution. 90 is not a scientific number, it just so happens that if the points returned are 774 (usually is), and 774 is divided by 774 (usually is), then a zoom of 90 works out pretty good.

And if the display resolution is changed, then the form will resize itself.

Will it look perfect? I doubt it. On a smaller resolution, say 800 by 600, it starts to look grainy. But the whole form is visible.

If this doesn't make sense, just ask.

Steve

This message was edited by stevebausch on 2002-09-22 19:42