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.

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


HTH. Best wishes Harald

"Skyhouse" skrev i melding
...
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.

Thanks a lot.

"Harald Staff" wrote:

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


HTH. Best wishes Harald

"Skyhouse" skrev i melding
...
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.