Fill Excel Screen with Form

[Lydon Bergin]

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

[Ron de Bruin]

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" <lydonbergin@gmail.com> wrote in message news:eazhLZdHGHA.1676@TK2MSFTNGP09.phx.gbl...
>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
>

[Lydon Bergin]

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" <rondebruin@kabelfoon.nl> wrote in message
news:OI0fUidHGHA.1332@TK2MSFTNGP10.phx.gbl...
> 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" <lydonbergin@gmail.com> wrote in message
> news:eazhLZdHGHA.1676@TK2MSFTNGP09.phx.gbl...
>>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
>>
>
>

[Ron de Bruin]

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" <lydonbergin@gmail.com> wrote in message news:OA$1V%23dHGHA.3936@TK2MSFTNGP12.phx.gbl...
> 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" <rondebruin@kabelfoon.nl> wrote in message news:OI0fUidHGHA.1332@TK2MSFTNGP10.phx.gbl...
>> 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" <lydonbergin@gmail.com> wrote in message news:eazhLZdHGHA.1676@TK2MSFTNGP09.phx.gbl...
>>>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
>>>
>>
>>
>
>

[Walt]

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