How do i change the positon of a form on the screen

spurs

Active Member
Joined
Oct 18, 2006
Messages
430
I have a form that appears whenever I turn on a function. The form is a button which stops the function.

The following code appears in the Forms section

Private Sub UserForm_activate()
ProbeStop = False
Call Live
End Sub
Private Sub CommandButton1_Click()
ProbeStop = True
End Sub


The subroutine Live runs until ProbStop=True


How do I move the postition of the CommandButton1 so that it doesnt block other activity on the screen?
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,007
Look at the Left and Top properties of the object (commandbutton or userform).
 

Watch MrExcel Video

Forum statistics

Threads
1,108,980
Messages
5,526,027
Members
409,680
Latest member
DonVito

This Week's Hot Topics

Top