userform fullscreen
 

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


--
Message posted via http://www.officekb.com

userform fullscreen
 

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

--
Ian
--
"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:56cd3877cd85f@uwe...
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


--
Message posted via http://www.officekb.com

userform fullscreen
 

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)


"Ian" wrote in message
...
With UserForm1
.Top = 1
.Left = 1
.Height = Application.UsableHeight
.Width = Application.UsableWidth
End With

--
Ian
--
"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:56cd3877cd85f@uwe...
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


--
Message posted via http://www.officekb.com

userform fullscreen
 

Hi Ian,

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

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

Hi experts,

[quoted text clipped - 3 lines]
Thanks,
Pierre


--
Message posted via http://www.officekb.com

userform fullscreen
 

See other thread

--

HTH

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


"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:56d97708921a7@uwe...
Hi Ian,

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

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

Hi experts,

[quoted text clipped - 3 lines]
Thanks,
Pierre


--
Message posted via http://www.officekb.com