View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dale Preuss[_2_] Dale Preuss[_2_] is offline
external usenet poster
 
Posts: 36
Default 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