This is how to make your userfrom fullscreen

On 2003-01-02 05:42, michaeldh wrote:
Hi Guy's,

This is how to make a userform go full screen...hope this helps.

With Application
.WindowState = xlMaximized
Zoom = Int(.Width / Me.Width * 100)
Width = .Width
Height = .Height
End With

Michael.

Click to expand...

On 2003-01-02 05:58, michaeldh wrote:
Hi,

Supprisingly enough the code works without the .Me

A couple of other people have suggested different ways of doing it.

Thanks for your help.

Michael.

Click to expand...

On 2003-01-02 05:49, Ivan F Moala wrote:

On 2003-01-02 05:42, michaeldh wrote:
Hi Guy's,

This is how to make a userform go full screen...hope this helps.

With Application
.WindowState = xlMaximized
Zoom = Int(.Width / Me.Width * 100)
Width = .Width
Height = .Height
End With

Michael.

Click to expand...

Hi Michael
Shouldn't that be

<pre/>
Private Sub UserForm_Initialize()

With Application
.WindowState = xlMaximized
Zoom = Int(.Width / Me.Width * 100)
Me.Width = .Width
Me.Height = .Height
End With

End Sub
</pre>

Me Key word missing

Click to expand...

On 2003-01-02 10:23, tusharm wrote:
Hi Ivan,

Inside a class module, which is what the userform code module is, the Me. is redundant. I guess the designers of VB(A) figured on saving a few keystrokes. Using Me still is very good programming practice. Personally, I wish it were enforceable.

Click to expand...