Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Properties - Last User | New Users to Excel | |||
Trouble with saving user input in an Excel Form. | Excel Discussion (Misc queries) | |||
Efficient User Form vba coding for saving to worksheet | Excel Programming | |||
Saving a Workbook: Forcing User to Rename before Saving | Excel Programming |