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

 

[Joe4]

Have you tried getting rid of these two lines?

Debug.Print t & ":" & Range("F11")
MsgBox t

I think they may just for demonstation purposes and may not be needed, and probably require you to do respond each time it comes to those lines.

 

[matthewlouis]

Have you tried getting rid of these two lines?

Debug.Print t & ":" & Range("F11")
MsgBox t

I think they may just for demonstation purposes and may not be needed, and probably require you to do respond each time it comes to those lines.

Yessir!!! That did it, thanks so much!

 

[Joe4]

You are welcome!

 

[matthewlouis]

Actually . . . that didn't work.

While it did process all 100 simulations at one time, it messed up the calcualtion . . . it failed to calculate the Failures vs, Successful . . . it made all of them positive.

 

[Joe4]

While it did process all 100 simulations at one time, it messed up the calcualtion . . . it failed to calculate the Failures vs, Successful . . . it made all of them positive.

I have no idea of what any of that is/means.
All you really provided was the code, without any data or explanation of what this is and how it works.
You just asked why it doesn't run all the loops automatically, and I explained why.

It sounds like you have a design and/or logic issues.

 

[matthewlouis]

I have no idea of what any of that is/means.
All you really provided was the code, without any data or explanation of what this is and how it works.
You just asked why it doesn't run all the loops automatically, and I explained why.

It sounds like you have a design and/or logic issues.

Sorry, I wasn't clear about that.

Basically, the algo gives a probability of success and failure using stock market data. That wasn't important to the "automatic" problem in the algo . . . until I deleted those two lines you suggested. Well, it is important because while it did automatically run it 100 times. However, F11 is a cell reference and must be important because by deleting it as part of the tow lines, it did change the algo's calculation.

 

[MARK858]

@Joe4 a bit more info in what I believe was the original post (based on the last post in the old thread) the OP mentions.

Donut Chart not Updating

Is there a reason why my donut chart won't update when the data changes? Do I not have a setting correct somewhere? I have calculations on automatic and when the data changes in my data table, it doesn't update the circle part to match the percentage. Thanks in advance!

www.mrexcel.com

 

[Joe4]

I have zero experience with donut/pivot charts, so I don't think I will be much help on this.

Since the question now is different than the original question, I suggest you start a new thread so that it appears as a new unanswered question, and might get more attention.
Be sure to include ALL the pertinent details in the question, so people understand the full scope of what you are trying to do.

 

[matthewlouis]

OK, thanks Joe!