Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to specify in my VBA code exactly where,
relative to the application, my user form will appear. None of the four defaults for "StartUpPosition" are exactly what I want. Can anyone tell me how to specify for example that the left edge of a user form should be 300 pixels to the right of the left side of the application and that its top should be 150 pixels below the top of the application? Thank you. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Chris,
set the form's startupposition property to manual (0), and then define the Left and Top properties as per your requirements. This should work...... Steve -----Original Message----- I would like to specify in my VBA code exactly where, relative to the application, my user form will appear. None of the four defaults for "StartUpPosition" are exactly what I want. Can anyone tell me how to specify for example that the left edge of a user form should be 300 pixels to the right of the left side of the application and that its top should be 150 pixels below the top of the application? Thank you. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
User Form | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming | |||
vbModal, VBA version, StartUpPosition Setting | Excel Programming | |||
vbModal, VBA version, StartUpPosition Setting | Excel Programming |