VBA change already activated (displayed) userform's position

[Sahak]

Hi all,

Is there a way to change already activated (displayed) UserForm's position on the screen?

Thank you in advance

 

[Rick Rothstein]

Is there a way to change already activated (displayed) UserForm's position on the screen?

Somehow, I don't think this is the answer you are looking for, but without more information telling us what you actually want to do...

1) Move the cursor over the title bar of the UserForm

2) Press and hold down the left mouse button

3) Move the cursor (the UserForm will follow)

4) Release the left mouse button when you have the UserForm in the position you want it.

 

[Sahak]

Thank you very much Rick for Reply.

I'm looking for VBA code, for example push a button on UseForm & it will change UserForm's position

 

[Rick Rothstein]

I'm looking for VBA code, for example push a button on UseForm & it will change UserForm's position

Change its position to where?

 

[Fluff]

How about

Private Sub CommandButton1_Click()
Me.Top = 201
Me.Left = 10

End Sub

 

[Sahak]

It woks, thank you very much Fluff.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Sahak]

I'm Sorry Rick, I missed your reply. To change from old position to the middle screen for example.