Hi all,

i was wondering how to make a normal user form has the option of FULL
SCREEN, just like how windows does?

Does anyone have a hint please?

ThankThank
Fendic


--
Fendic
------------------------------------------------------------------------
Fendic's Profile: http://www.excelforum.com/member.php...o&userid=23959
View this thread: http://www.excelforum.com/showthread...hreadid=380926

Hi Fendic,

Fendic wrote:
i was wondering how to make a normal user form has the option of FULL
SCREEN, just like how windows does?

Does anyone have a hint please?

I don't think there's any way to truly make a UserForm go fullscreen. But
you could do something like this:

With Application
.WindowState = xlMaximized
Me.Move .Left, .Top, .Width, .Height
.Visible = False
End With

This will move the UserForm and resize it so that it takes up the whole
screen. It will also hide the Excel application (you can comment out the
..Visible=False line if you don't wish to do this). Just make sure that if
you do hide the Excel app, you provide a mechanism for making it visible
again when the UserForm is closed.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]