Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the following code to make the userform fill the entire screen:
Private mlAppWindowState As Long Private Sub UserForm_Initialize() With Application mlAppWindowState = .WindowState .WindowState = xlMaximized Me.Move .Left, .Top, .Width, .Height End With End Sub Private Sub UserForm_Terminate() Application.WindowState = mlAppWindowState End Sub What I need is VBA to center the userform controls. Maybe I could put the controls inside a frame and I just need to the frame to center. I am not sure. But I need VBA to position the controls. Can someone get me started? -- Thanks Shawn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
userform to appear in the center of the screen | Excel Programming | |||
userform to appear in the center of the screen | Excel Programming | |||
mutlipage in the center of userform | Excel Programming | |||
UserForm position other than center of the screen. | Excel Programming | |||
textbox in userform(vertical center) | Excel Programming |