It is almost impossible to determine a UserForm's required width to display a given title. I am unable to find out the used font and it's size which I could use in a temporary Label or TextBox to obtain it's Width property.
Currently a temp TextBox is used together with a formula which tries to come as close as possible. The result however is still not satisfying me.
It is almost impossible to determine a
UserForm's required width to display a given title. I am unable to find out the used font and it's size which I could use in a temporaryLabelorTextBoxto obtain it'sWidthproperty.Currently a temp TextBox is used together with a formula which tries to come as close as possible. The result however is still not satisfying me.