user form properties not saving
 

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

user form properties not saving
 

right click on the box. click on Format Control. and on properties ta
change to move and size with cell

--
john q publi
-----------------------------------------------------------------------
john q public's Profile: http://www.excelforum.com/member.php...fo&userid=1578
View this thread: http://www.excelforum.com/showthread.php?threadid=27293

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

user form properties not saving
 

"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
"Dale Preuss" wrote:

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

Dale,

Worked like a charm!
Still I wonder why these don't simply save along with the rest of the file?
For example I have the ShowModal property set to False and that stays as
False.

amescha