Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a UserForm to appear!
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a UserForm to appear!
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a UserForm to appear!
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making a userform work ,oops | Excel Programming | |||
making a userform work | Excel Programming | |||
Making your UserForm print other workbooks | Excel Programming | |||
Making a TextBox look and feel like a Label in a userform | Excel Programming | |||
Making a TextBox look and feel like a Label in a userform | Excel Programming |