Hi
Above is the code I have.![]()
Sub Button1_Click() Range("T23").Select Selection.ClearContents End Sub Sub test() Application.OnTime Now + TimeValue("00:00:10"), "Repeat_VBA" End Sub
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
Bookmarks