Mr Wilson maybe you could help me out again. This might be easier than my previous need, which i greatly appreciate your help.
I have 3 monitors that I am using set up in a pyramid 2 on bottom and a 55" display above. When I go to the slide show and run the userform they do not appear on the same screen. I tried to use the properties postion but when I center it it puts it in the middle of all 3 screens. I also tried the following code
Code:
Private Sub FastConnectSearch_Initialize()
Dim TopOffset As Integer
Dim LeftOffset As Integer
TopOffset = (Application.UsableHeight / 2) - (Me.Height / 2)
LeftOffset = (Application.UsableWidth / 2) - (Me.Width / 2)
Me.Top = Application.Top + TopOffset
Me.Left = Application.Left + LeftOffset
End Sub
FastConnectSearch is the title of my userform. This however is putting it at the top left of the bottom screen. Is their away to assign the userform to open in the same screen as the show regardless of what screen it is on?