Fill Excel Screen with Form
 

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

Fill Excel Screen with Form
 

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

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

Fill Excel Screen with Form
 

Hi Lydon

You can add all your controls inside a frame and change the Top and Left property of the frame
when you open the userform.


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


"Lydon Bergin" wrote in message ...
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

Fill Excel Screen with Form
 

Hi Lydon,

For some really interesting things you can do with userforms, check
out:

Stephen Bullen's Excel Page
http://www.oaltd.co.uk/Excel/Default.htm
FormFun.zip

Best Regards,
Walt