Maximize Userform

H

Howard31

Hi All,

I've written the following in the Innitialize Userform event to have a
Maximize button on the Userform.

Style = GetWindowLong(hWnd, GWL_STYLE)
Style = Style Or WS_MAXIMIZEBOX Or WS_MINIMIZEBOX Or WS_SYSMENUE Or
WS_CAPTION
SetWindowLong hWnd, GWL_STYLE, Style

My question now is how to tell VBA to open the userform in Maximize Mode?
 
M

Mike H

Hi,

You could try this

With Me
.Height = Application.UsableHeight
.Width = Application.UsableWidth
.Left = 0
.Top = 0
End With

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show/Hide Minimize/Maximize Button in Excel 2007/2010 2
Code locking up until I press the reset button 0
Userform Causing Screen to Hang 0
Excel Application to MS Access Application 2
Scrolling etc a Userform 2
Adding and Graying MAXIMIZE button on vba E2007 form system menu 2
How do I set focus (and select text) on a text box on a modeless userform? 0
Splash screens from VBA! 7

Top