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