Userform object will not center on maximize

[oblix]

Hi there
I am trying to make userform full screen size and center the object once maximized.
I have achieved the full screen part, but my code does not send object to center of screen, but top left instead.

My code is as follows:

Private Sub UserForm_Activate()

Me.Height = Application.Height
Me.Width = Application.Width
Me.Left = Application.Left
Me.Top = Application.Top

Me.MultiPage1.Left = (Me.MultiPage1.Width / 2) - (Me.MultiPage1.Width / 2)
Me.MultiPage1.Top = (Me.MultiPage1.Height / 2) - (Me.MultiPage1.Height / 2)

End

Please help!
Thank you

 

[6StringJazzer]

I don't have time to create your form from scratch for testing but try this:

Private Sub UserForm_Activate()

   Me.Height = Application.Height
   Me.Width = Application.Width
   Me.Left = Application.Left
   Me.Top = Application.Top

   Me.MultiPage1.Left = Me.Width / 2 - Me.MultiPage1.Width / 2
   Me.MultiPage1.Top = Me.Height / 2 - Me.MultiPage1.Height / 2

End

 

[jasonb75]

Please have a read of this link, if your code was any longer I would not have replied, unformatted code can be difficult to read. You will see from the link that formatting your code correctly is very simple and makes it easier for people helping you. I believe that using tags is only a suggestion here but many other forums insist on it as a rule and some are very strict with it.

How to Post Your VBA Code

Post your VBA code.

www.mrexcel.com

To answer your question, the first part of the calculation needs to refer to the form width, not the object width.

Me.MultiPage1.Left = (Me.Width / 2) - (Me.MultiPage1.Width / 2)
Me.MultiPage1.Top = (Me.Height / 2) - (Me.MultiPage1.Height / 2)

 

[oblix]

Thank you to both

[FONT=arial]6StringJazzer[/FONT] and jasonb75 for the answer​

Sorry for pasting wrongly and will format the code according to link.

 

[jasonb75]

Sorry for pasting wrongly and will format the code according to link.

It's not wrong (or at least not on this forum) it just makes it stand out from the rest of your post so that it's easier to read. Sometimes the moderators will edit your post and add the tags if they see unformatted code, but I've never known them to take any action against anyone not doing it (unlike a certain other forum that both Jeff and myself are familiar with).

 

[6StringJazzer]

The rules of this forum do not require code tags but here is why they are a good idea:

• The spacing in your code is preserved in code tags. Otherwise leading spaces on a line are removed for display.
• It is presented in a monospaced font, which makes it more readable since spacing is often deliberate in code
• Keywords are color-coded
• Long code appears in a scroll box so it does not clutter up the page