I have been experiencing issues with Userforms that I have created.
ISSUE #1: The size of the Userform, while defined by setting the left and lower positions when creating the form as well as defining it in the code in a "With" statement, does not always open at the size it should.
Example:
With Userform1
Userform1.Height = 115
Userform1.Width = 340
Userform1.Show
End With
ISSUE #2: After using the form a couple of times, the font size will randomly chant in size. It always ends up being an obnoxiously large font causing me to need to manually correct all points in the Userform.
Is there a setting that I am missing that will correct this and prevent it from happening in the future?
ISSUE #1: The size of the Userform, while defined by setting the left and lower positions when creating the form as well as defining it in the code in a "With" statement, does not always open at the size it should.
Example:
With Userform1
Userform1.Height = 115
Userform1.Width = 340
Userform1.Show
End With
ISSUE #2: After using the form a couple of times, the font size will randomly chant in size. It always ends up being an obnoxiously large font causing me to need to manually correct all points in the Userform.
Is there a setting that I am missing that will correct this and prevent it from happening in the future?