FranktheBank
Member
Hello again,
I had this working before but, for some reason I messed it up. I have a UserForm called "New_Line_Insert" and I'm trying to get it near the top right hand side of the screen.
I have the following code in my 'ThisWorkbook'
No good, I've tried:
I've also put these Codes on mySheet4 Object where it is supposed to be working!!
The Userform is appearing but it is in the middle to the Left of the screen??
I had this working before but, for some reason I messed it up. I have a UserForm called "New_Line_Insert" and I'm trying to get it near the top right hand side of the screen.
I have the following code in my 'ThisWorkbook'
Code:
Private Sub UserForm_Activate()
With New_Line_Insert
.Top = Application.Top + 1025 '< change 125 to what u want
.Left = Application.Left + 2025 '< change 25 to what u want
End With
End Sub
Code:
Private Sub UserForm_Activate()
With UserForm
.Top = Application.Top + 1025 '< change 125 to what u want
.Left = Application.Left + 2025 '< change 25 to what u want
End With
End Sub
I've also put these Codes on mySheet4 Object where it is supposed to be working!!
The Userform is appearing but it is in the middle to the Left of the screen??