Making a UserForm to appear!

[Guest]

Is there a way to make the UserForm appear in a specific part of the
spreadsheet and have it appear in that spot every time it is opened? Thanks
for any help.

 

[Harald Staff]

Sub showup()
With UserForm1
.StartUpPosition = 0
.Top = Application.Top + 142
.Left = Application.Left + 29
.Show
End With
End Sub


HTH. Best wishes Harald

 

[Guest]

Thanks a lot.

Sub showup()
With UserForm1
.StartUpPosition = 0
.Top = Application.Top + 142
.Left = Application.Left + 29
.Show
End With
End Sub


HTH. Best wishes Harald