View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lydon Bergin Lydon Bergin is offline
external usenet poster
 
Posts: 6
Default Fill Excel Screen with Form

Excellent, thanks a lot. Any advice on how to keep my controls centered no
matter the resolution?

Lydon D. Bergin
MCP, MOS


"Ron de Bruin" wrote in message
...
Userform ??

Copy this event in the userform module

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Lydon Bergin" wrote in message
...
I was wondering if there is anyway that you can fill the excel window with
a form (Like maximized within the excel window)? Thanks for your help.


Lydon D. Bergin
MCP, MOS