Thread: Fill Excel Screen with Form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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



Reply With QuoteReply With Quote