Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
aligning a form on the screen
A form is displayed when my macro runs. Right now it is
in the center of my screen. I would like to keep it in the center but move it to the far right of the screen. Is there a way to program this? I have looked at the properties but none of do what I would like the form to do. Thanks for the help...... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
aligning a form on the screen
JT,
This is interesting. I assumed you would use the Left property in the UserForm Initialize module. However it only works if I put in the Activate module: Private Sub UserForm_Activate() Me.Left = ActiveWindow.Width - Me.Width End Sub hth, Doug Glancy "JT" wrote in message ... A form is displayed when my macro runs. Right now it is in the center of my screen. I would like to keep it in the center but move it to the far right of the screen. Is there a way to program this? I have looked at the properties but none of do what I would like the form to do. Thanks for the help...... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print form on screen? Help!! | Excel Discussion (Misc queries) | |||
Aligning decimal numers to the centre of the cell and aligning dec | Excel Discussion (Misc queries) | |||
How do I get rid of my form from the screen? | Excel Programming | |||
How to position form in same place with different screen resolutions | Excel Programming | |||
Log On Screen / Form | Excel Programming |