Fill Excel Screen with Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lydon Bergin - 20 Jan 2006 15:29 GMT

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

Reply to this Message

Ron de Bruin - 20 Jan 2006 15:45 GMT

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

Signature

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

>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

Reply to this Message

Lydon Bergin - 20 Jan 2006 16:35 GMT

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

Lydon D. Bergin
MCP, MOS

> Userform ??
>
[quoted text clipped - 14 lines]
>> Lydon D. Bergin
>> MCP, MOS

Reply to this Message

Ron de Bruin - 20 Jan 2006 16:45 GMT

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.

Signature

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

> Excellent, thanks a lot. Any advice on how to keep my controls centered no matter the resolution?
>
[quoted text clipped - 19 lines]
>>> Lydon D. Bergin
>>> MCP, MOS

Reply to this Message

Walt - 20 Jan 2006 19:17 GMT

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

Reply to this Message