Auto click macro button

Hi

Please Login or Register  to view this content.

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

You're trying to call a procedure called "Repeat_VBA", but it doesn't exist. In addition, the 'Test' procedure is not part of the click event so will never run from the button.

The correct way to do it would be

Please Login or Register  to view this content.

But I don't think that you can call a click event in that way, you will most likely need a 2 part procedure with valid names and references (untested, just done on the fly)

Please Login or Register  to view this content.