• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Happy Valentine's Day!

@Eloise T

Yes, it would go faster because each click essentially works as a separate instance of Application.OnTime
To prevent this we just need to tell it to run the StopHearty code first with Application.Run & then carry on with its own code
Just didn't put that bit in

The Heart shape was manually made
-Just zoomed out, coloured some cells till it looked like a heart
- Then selected them & turned the selection into a named range
- Then referred to the named range in the macro
 
@Eloise T

Yes, it would go faster because each click essentially works as a separate instance of Application.OnTime
To prevent this we just need to tell it to run the StopHearty code first with Application.Run & then carry on with its own code
Just didn't put that bit in

The Heart shape was manually made
-Just zoomed out, coloured some cells till it looked like a heart
- Then selected them & turned the selection into a named range
- Then referred to the named range in the macro
iu
 
Back
Top