User Forms

[Guest]

How can I get a user form to maximize on user screens during show process? I have played with Zoom but need more. Thanks for your help

 

[William]

Hi Sgwapt

Private Sub UserForm_Initialize()
With Me
..Height = Application.Height
..Width = Application.Width
End With
End Sub

Note that objects on the UserForm will not adjust in size proportionately to
the UserForm's size

--
XL2002
Regards

William

(e-mail address removed)

| How can I get a user form to maximize on user screens during show process?
I have played with Zoom but need more. Thanks for your help
| --
| George G

 

[Harald Staff]

You shouldn't use the entire screen for trivial information like this. The
user should be allowed to browse the web or watch a movie in the meantime.
Use no more than this info needs, probably something like 300*50 pixels.

HTH. Best wishes Harald

How can I get a user form to maximize on user screens during show process?

I have played with Zoom but need more. Thanks for your help

 

[Guest]

Thanks William, this helps very much. Al I have to do now is adjust the objects.

Thanks again

 

[Guest]

Yes, I understand your message Harald. My only Intention is for database systems at work. I have been having problems with "button happy", "not authorized", "changing values", etc personnel that I have to prevent the data from being changed by them as these systems get bigger. I am trying to change to XLA format that will take care of this but boss man is in the way.

Thanks for the feedback. I will keep plugging and enjoy.

 

[Harald Staff]

Yes, I understand your message Harald. My only Intention is for database

systems at work. I have been having problems with "button happy", "not
authorized", "changing values", etc personnel that I have to prevent the
data from being changed by them as these systems get bigger. I am trying to
change to XLA format that will take care of this but boss man is in the way.

I can feel your pain. Good luck with this project.

Best wishes Harald