You can make the userform larger, but it isn't a zoom type operation - the
controls on the form will not resize:

Sub UserForm_Activate()
With Application
'maximize Excel
.WindowState = xlMaximized
Me.Top = .Top
Me.Left = .Left
Me.Height = .Height
Me.Wdith = .Width
End With
End Sub


Sub FormFit()
UserForm1.Show
End Sub


The above assumes excel is maximized. (I added code to maximize it)


The activate event is in the Userform code module.

--
Regards,
Tom Ogilvy



"eyesonly1965" wrote:


hello i have been searching and searching,
but can't find anything about opening a form maximized.

can anyone tell how to do this?


--
eyesonly1965
------------------------------------------------------------------------
eyesonly1965's Profile: http://www.excelforum.com/member.php...o&userid=34199
View this thread: http://www.excelforum.com/showthread...hreadid=539653