Userform Issues

jmk15315

Board Regular
Joined
Nov 7, 2021
Messages
73
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
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?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Hi,
firstly, you With Statement written that way serves no purpose - it should be

VBA Code:
  With UserForm1
        .Height = 115
        .Width = 340
        .Show
    End With

with regard to your issue - I seem to recall experiencing similar problem when I was using Office 2013 & running the REPAIR tool sort of fixed it or so it seemed. Maybe worth giving this try.
Other than that & without seeing your workbook a little difficult to offer further suggestions but maybe others here will have other ideas they can offer you.

Hope helpful

Dave
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top