Userform too big

[AnnetteTR]

Hi
I have made a large makro, that also uses a Userform - I made it using a computer with a large extern screen.
Now I have to use the macro on a laptop with a smaller screen - this means that some of the Userform cannot be seen on the screen.
I would like to solve this in one of two ways.
1 - the userform should take size relative to the actual screen size
or
2 - the userform should have something like a scrollbar if it is bigger than the screen.

How can that be achieved?

Regards Annette

 

[VoG]

Maybe like this in the form's code module

Private Sub UserForm_Activate()
With Application
    Me.Top = .Top
    Me.Left = .Left
    Me.Height = .Height
    Me.Width = .Width
End With
End Sub

Or http://www.andypope.info/vba/resizeform.htm

 

[AnnetteTR]

Hi Vog

Thankyou
Now I can see everything on the userform - is it possible to keep the proportions (length/ width)?

The other solution is too ambitious.

Regards Annette

 

[VoG]

Hi. I think that you would need something like this http://www.andypope.info/vba/Anchor.htm

 

[AnnetteTR]

Hi VoG (and others)

I have used your suggestion on a couple of PC's
I still have one problem.
The userform adjust to the actual monitor, but if the monitor is too small
the content of the userform cannot be seen.
Is there a way to let the content size with the Userform size?

Regards Annette

 

[NdNoviceHlp]

HTH. Dave http://www.mrexcel.com/forum/showthread.php?t=547071&page=2