Auto resizing forms.

[Amine]

Hello,
I found a vba code that is used to resize a form according to the size and resolution of each screen.
I followed the instructions by changing some parameters on my form and then I placed the vba code and everything works perfectly.
My problem is that I have 10 forms in my application and it will be better to have a single module that I call by one or two lines on each form instead of pasting all the code on all the forms.

https://stackoverflow.com/questions/...ic-form-resize



Any suggestions please?

[Welshgasman]

That is how this one works I believe?, however you would still need to add a line to each form to call the code?

https://isladogs.co.uk/automatic-for...g-1/index.html

[Amine]

That is how this one works I believe?, however you would still need to add a line to each form to call the code?

https://isladogs.co.uk/automatic-for...g-1/index.html

This is not the same code.
I prefer to use the code I found.
I just want this code to be in a module and call it on each form.

[CJ_London]

Haven't spent the time looking at the code and not clear whether you are using all or some of the subs but you can move them to a general module, renaming to a certain extent - for example, the form_load sub would become a function

Public Function frmLoad(frm as form)
     
    fontZoom = 1
    SaveControlPositionsToTags frm

End Function

Then in the form event properties put

=frmLoad(FORM)

instead of [Event Procedure]

or if you use the actual event

Form_Load()
    frmLoad Me
End Sub

for those subs with parameters you will have to go the second way or use a class module

the SaveControlPositionsToTags should work unchanged in the new module since it is already declared as public

[isladogs]

You can of course spend time adapting the code you found on StackOverflow but its a far more complex method of achieving the same result as you will get from my code in the link provided in post #2 by @welshgasman.
If you use my code, you need to import the module modResizeForm to your app and add one line of code ResizeForm Me to the Load event of each form. That's basically all you need to do!

Your choice.