user form StartUpPosition
 

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.

user form StartUpPosition
 

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.
.