Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i get an form to fill up my excel sheet? | Excel Discussion (Misc queries) | |||
Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
Color Fill for a cell does not appear on Excel screen | Excel Worksheet Functions | |||
Excel as fill-in form | Excel Discussion (Misc queries) | |||
can excel be opened to fill screen size available | Excel Discussion (Misc queries) |