UserForm Sizing

[THarte]

Is there any way to make a userform cover the whole excel interface (minus toolbars)regardless of whether the Excel Window is maximized or made smaller?

 

[xlbo]

Try something like :
Userform activate event
Me.Height = activewindow.usableheight
me.width = activewindow.usablewidth
me.left = activewindow.left

You may need to jigger about with the form startup position as well
HTH
Geoff

 

[THarte]

I am able to get the TOP setting right on the alignment of the form but no matter what value I put in LEFT the form stays glued to the left side of the screen. I have put values from -500 to 500 in there and it does not budge.

 

[THarte]

Never Mind, I got it. Kill the LEFT statement in the Activate Event and adjust Manually. Thanks!