The code works, but even after closing the form using "End" in a sub that is supposed to stop all macros, it keeps running even if I open VBA editor and hit the stop button it keeps running. The idea is when the form is showing the code will keep running, but after I close the form (or even happy if it's a macro button I have to push at end of the day to stop it) the timer should stop running.
The code is basically checking every 10 secs that certain windows are sized properly because they tend to want to resize themselves randomly :D sadly out of my control as the other program belongs to a diff company.
The code is basically checking every 10 secs that certain windows are sized properly because they tend to want to resize themselves randomly :D sadly out of my control as the other program belongs to a diff company.
VBA Code:
Sub Window_Resize_Time()
Application.OnTime Now + TimeValue("00:00:10"), "WindowResize"
End Sub
Sub WindowResize()
If Tools_Form.Label1662.Caption = "Call" Then
SendKeys "^{F2}"
Call Window_Resize_Time
Else
End If
End Sub