Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » User Form Windows

User Form Windows

ResolvedVersion 2007

Fri 19 Mar 2010, 11:35 Delegate Eve said...

Eve has attended:
Excel VBA Intro Intermediate course

User Form Windows

Is there a way to control the size of a user form when it opens up on different screen resolutions eg an autofit option? We have had instances where the user form displays fine on a desktop PC but does not fit onto a laptop screen.

Mon 22 Mar 2010, 12:14 Trainer Stephen said...

RE: User Form Windows

Hi Eve

Thanks for your question

after some playing around I have come up with the following code which seems to do the trick

Private Sub UserForm_Initialize()



    With ActiveWindow



        .WindowState = xlNormal

        .Top = 1

        .Left = 1

    

    End With

    

    With Me



        .Width = Application.UsableWidth

        .Height = Application.UsableHeight



    End With



End Sub

I have tried this on different screen resolutions and it seems to work OK.

Regards

Stephen

Mon 29 Mar 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Change the Print button so it brings up the Print dialogue box

If you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following:

1. Right-click on the toolbar that displays the Print button.

2. Select Customise.

3. Click on the Print button on the toolbar to select it, then hold the left mouse button down and drag the button towards the screen below. The button should come off the toolbar.

4. In the Customise dialogue box on your screen, select the Commands tab.

5. Select File from the Categories list, and then locate the Print... icon (looks like the normal Print button, but the word Print has three dots following it).

6. Click on the Print... icon to select it, then use your left mouse to drag and drop the icon onto the toolbar at the top of the screen.

7. Close the Customise dialogue box.

View all Excel hints and tips

User Form Windows

User Form Windows

RE: User Form Windows

Excel articles

Excel tip:

Change the Print button so it brings up the Print dialogue box