Hi
Above is the code I have.
I have created a button which when clicked manually clears the contents in T23, as seen in the top half of the code.
I have written the second half of the code in the hope it will auto click the button every 10 seconds but it doesn't do anything.
Code:
Sub Button1_Click()
Range("T23").Select
Selection.ClearContents
End Sub
Sub test()
Application.OnTime Now + TimeValue("00:00:10"), "Repeat_VBA"
End Sub
Above is the code I have.
I have created a button which when clicked manually clears the contents in T23, as seen in the top half of the code.
I have written the second half of the code in the hope it will auto click the button every 10 seconds but it doesn't do anything.
Can anyone see what's wrong with this?
Thanks
Thanks