Dfense
01-23-2008, 04:49 PM
I found some code on how to re-positon a uerform upon startup and pasted it into my module. It works okay except when I click on a "non active" area of the userform...I get a compile error that looks like this. Can someone explain my problem with the code I am using?
Private Sub UserForm_Click()
Option Explicit
With UserForm1
Top = Application.Top + 182 '< change 125 to what u want
Left = Application.Left + 667 '< change 25 to what u want
End With
End Sub
Thanks,
Private Sub UserForm_Click()
Option Explicit
With UserForm1
Top = Application.Top + 182 '< change 125 to what u want
Left = Application.Left + 667 '< change 25 to what u want
End With
End Sub
Thanks,