Thread: Is it possible
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ozgur Pars[_2_] Ozgur Pars[_2_] is offline
external usenet poster
 
Posts: 70
Default Is it possible

Sub UserForm_Initialize()
With Application
Me.Top = .Top
Me.Left = .Left
Me.Height = .Height
Me.Width = .Width
End With

End Sub

"T.c.Goosen1977" wrote:


I know that on can manually set the userform launching possition but is
it possible for the userform to fill the full screen automatically when
you load it...reason...so u have the same visual when working on a 15,
17 or 19" screen.
Thanks
Theuns


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=558364