user form properties not saving
In the form module, add...
Private Sub UserForm_Initialize()
Me.StartUpPosition = 0
Me.Top = Application.Height - Me.Height
Me.Left = 0
End Sub
Depending on your resolution, the form may not be perfectly seated in the
corner. But it will be close.
Dale Preuss
"amescha" wrote:
Hello All.
I have a simple user form that I want to have in the lower left hand part of
the screen when the form is shown. I can set the properties just fine and all
is well, until I save the file, at which point the form goes back to a
default size and position on the screen. This happens whether I am on a
Windows2000 or XP platform. This is a simple user form with just four option
button but I'd like to keep it out of the way of the Chart that is being
displayed. Specifically the option buttons change the scale of the chart.
Probably something simple but I need help just the same, thanks in advance!
Charles Ames
U of O
Eugene OR USA
|