userform fullscreen

[Pierre via OfficeKB.com]

Hi experts,

I would like to have my userform fullscreen so that the screen resolution
does not matter anymore..
oes somebody have the code for that ?
Thanks,
Pierre

 

[Ian]

With UserForm1
.Top = 1
.Left = 1
.Height = Application.UsableHeight
.Width = Application.UsableWidth
End With

 

[Bob Phillips]

This uses the usable area, but if you want to cover the whole Excel app,
then use

Application.WindowState = xlMaximized
With Application
Me.Top = .Top
Me.Left = .Left
Me.Height = .Height
Me.Width = .Width
End With


If you want true maximize like a standard app, you need APIs.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Pierre via OfficeKB.com]

Hi Ian,

Do you also know how to get a multipage centered on a userform ?
thanks man !
Pierre

With UserForm1
.Top = 1
.Left = 1
.Height = Application.UsableHeight
.Width = Application.UsableWidth
End With

Hi experts,

[quoted text clipped - 3 lines]

Thanks,
Pierre

 

[Bob Phillips]

See other thread

--

HTH

RP
(remove nothere from the email address if mailing direct)

Hi Ian,

Do you also know how to get a multipage centered on a userform ?
thanks man !
Pierre

With UserForm1
.Top = 1
.Left = 1
.Height = Application.UsableHeight
.Width = Application.UsableWidth
End With

Hi experts,

[quoted text clipped - 3 lines]

Thanks,
Pierre