Vba Forms resizing themselves

[steveh8204]

I am creating forms and setting the size but when I run them the are automatically resizing quite large. Even when I go back and change back they go large again the next time I run it.

None of the elements within are set to auto resize and I don't believe there is an auto resize on the form itself.

I've even set the size in the initialize function but it doesn't make a difference.

Has anyone else had this issue?

 

[Jeffrey Mahoney]

Are you running this on different computers with different resolutions?

You could add some code in the UserForm_Initialize SUB to resize it.

Private Sub UserForm_Initialize()
  UserForm1.Width = 420
  UserForm1.Height 211.2
End Sub

 

[steveh8204]

Are you running this on different computers with different resolutions?

You could add some code in the UserForm_Initialize SUB to resize it.

Private Sub UserForm_Initialize()
  UserForm1.Width = 420
  UserForm1.Height 211.2
End Sub

I've just had a further play around and it seems to be due to my laptop display settings. As it's a small screen it's at 150% zoom.

If I select 100% zoom, edit the form and save them go back to 150% zoom it's fine. Just if I save while zoomed it reverts to much bigger.

A bit stupid but at least I've got a work around. I'd already tried the code in the initialize function although I'd used Me instead of the form name but either way it makes no difference.

Thanks anyway.