Control height/width properties and position in userform (Excel 2010)

[Mattantaliss]

Hello,

I'm playing around with creating a userform in Excel 2010 (under Windows 7). I have set the form's width to 250 (and the position is set to Left=0 and Top=0). I then added a frame to the form and set its width to 240. Now, the arithmetic would tell me that setting the "Left" value of the frame to 5 would center that frame horizontally in the form, but that is not the case. By formatting the frame to be centered horizontally (via clicking through the menus) and examining the "Left" value, I see it is set to 2.65.

What is going on here?

 

[Andrew Poulsom]

I imagine that allowance is being made for the UserForm's border. Left is from the inside of the UserForm.

 

[Mattantaliss]

Do you know if the allowance (or border size) is constant for all forms and controls?

 

[Andrew Poulsom]

Sorry, I don't know.