I am using a modeless userform which I want to postion at top-left corner of worksheet(above cell A1) when the form is activated.
I was using below code:
How do I change the code to put the form on top-left of worksheet?
I was using below code:
Code:
Private Sub UserForm_Activate()
'// Form position with respect to application window
With frmMenubar
.Top = Application.Top + 170 '< change 125 to what u want
.Left = Application.Left + 35 '< change 25 to what u want
End With
End Sub
How do I change the code to put the form on top-left of worksheet?