UserForm Display Location

[cicconmr]

Pretty simple: My UserForm is displaying in a random location, and since this workbook is going to go out to clients, I'd like to have the UserForm display in the middle of their screen each time it is shown.

Is there a way to force it to do that? Right now, my user form is displaying in the monitor right of the monitor my Excel is open in which makes no sense....(I have three monitors, I run excel in the middle, the UserForm shows up in my far right one)

Any one encountered this problem or have a solution?

 

[baitmaster]

Yep, I get this when using multiple monitors

Use userform.Top and userform.Left to set the positions. You can store these values in variables when the form is moved, using the userform_layout event, and then recall them when needed - so the form will reopen wherever it last was

 

[cicconmr]

Hey I don't mean to sound daft but how exactly can I do this. Can I just set Userform.Top = some parameter and same with userForm.Left?

Sorry I didn't quite understand...

 

[baitmaster]

Your userform has properties, these are displayed in the Properties window of the VB Editor

Any of these properties can be set in the properties window - which sounds like what you want to do - and also adjusted in your code, such as when using the Userform_Initialize event

Try adding the following code to your userform:

Private Sub UserForm_Layout()
Application.StatusBar = "top= " & UserForm1.Top & ", left = " & UserForm1.Left
End Sub

This will show you how the top and left parameters vary as you move your form around. You will need to type "application.statusbar = false" into the immediate window when you are finished playing with this

 

[cicconmr]

Last question then, are those figures relative for different screen sizes?

 

[baitmaster]

I believe it is measured in Twips, but I can't tell you how the value varies on different types of screen size combinations, sorry