Macro Doesn't Run Automatically

[matthewlouis]

Several months ago, I had some help creating the following macro.

Sub clicky()
For t = 1 To 100
Application.Calculate
Range("J10").Value = Range("J10").Value + 1
If Range("F11").Value <= 0.8 Then Range("J12").Value = Range("J12").Value + 1
Debug.Print t & ":" & Range("F11")
MsgBox t
Next t
End Sub

The macro works well except for one thing. It doesn't run automatically. When I hit CTRL-Shift-C, I want it to run the macro automatically 100 times. However, I am having to hit the Esc button each time to run ONE simulation, or 100 times to complete it. Am I missing a line in the code? I circled back to the person who helped write this code but I never heard back from him . . . it's been 3 months . . . so I hope the moderators understand this isn't a re-post.

Thanks in advance!

Several months ago, I had some help

 

[matthewlouis]

J12 is the Failures calculated by:

1. When 300 simulations run, 77% of 300 is 232 Successful.

2. 300 - 232 = 68 Failures

 

[GWteB]

@matthewlouis imo it would be best to upload your workbook to a file share facility on the net like DropBox or WeTransfer and to provide a link in this thread so we're able to have a closer look.

 

[Zyndstoff]

@matthewlouis imo it would be best to upload your workbook to a file share facility on the net like DropBox or WeTransfer and to provide a link in this thread so we're able to have a closer look.

Very true. Even the answers to our questions are cryptical.

 

[matthewlouis]

Guys, I apologize. I have uploaded workbooks before but I will have to familiarize myself (again) with the xl2BB process to load my workbook on here.

Thanks for ALL your help, so to be sorry to be so frustrating and cryptic, you're right, you must see the workbook, I get it. I just thought getting it to automate would be simpler.

 

[GWteB]

I just thought getting it to automate would be simpler.

That's a mistake many of us make once in a while. Nevertheless, success with your project!

 

[Zyndstoff]

I'll send you a private message with my email, you can send me your workbook.

 

[matthewlouis]

Thanks again!!

 

[Fluff]

@Zyndstoff
Please do not ask for files to be shared privately, as it is against board policy.
All communication (including sharing files) must remain on the board.
Thanks

 

[Zyndstoff]

@Zyndstoff
Please do not ask for files to be shared privately, as it is against board policy.
All communication (including sharing files) must remain on the board.
Thanks

My bad... sorry, won't happen again.