Stack overflow? PLEASE HELP

Hey guys, you've been so much help in the past, I figured I'd bring my >seemingly< final question to you.

So my code works fine, until I add in a few addition if statements, (by a few I mean it could be just one of the if statements or all 20ish that I'm adding in, the problem still persists)

Please Login or Register  to view this content.

I can post the full block of code if needed below.

Any insight would be appreciated. Please ask any questions and I will get back to them within a moment or two. Thanks!

can you post a sample workbook with this issue please?

Rather than adding all of those value changes in the same sets of ranges, make a separate Sub() and place it in a module and call it from your sheet's change event. Just pass the input parameter values. This is called Modular programming. I can show you if needed.

The other thing that you should do is to turn off screen updating, maybe automatic calculation, but positively turn off events. The other thing that you should do is to replace If()'s with Select Case. My rule-of-thumb on If()'s is no more than 2. Select Case will not always be the solution but should be considered in cases like yours. By doing these changes, it reduces the stack and makes code maintenance much easier.

The concepts above, less the call to a Sub() is shown below.

Please Login or Register  to view this content.

Hey TMS,

That solves the stack overflow problem, thanks! Although now it seems the code doesn't seem to run continuously? I can only select the value once and it will populate but then it stops working. I could post a sample workbook but I don't know how to upload it?

Could you please explain what you just said like I'm five? I'm still new to this and don't exactly understand what you mean. Thanks!

Hey Kenneth,

Thanks for the well thought out reply, unfortunately it's so hard for me to understand what you're saying, and that code boggles my mind. If I could upload a sample workbook perhaps that would help more... What does turning off screen updating do, or automatic calculation. I know what the select case is, and I should definitely use that now that you mentioned it. Thanks!

So apparently my excel file is 1.2mb and I can't attach anything that big. it would be helpful, I deleted everything that isn't necessary for the most part but I'm unable to upload it. Thanks for the detailed response, that makes sense to me. I put enable events = false before and = enable after (the if statement section) but it still only works once... any way to reduce file size or an alternate place to uplaod?

I will try that code, thanks for the insight. What does "option explicit" do?

Here is the link to the sample workbook, it's on dropbox. Thanks for the idea Kenneth. your code is getting more and more complicated and I'm understanding less and less of it. Please help me out here, Thanks for all the help both of you!

https://www.dropbox.com/s/i7nziazyxg...cert.xlsm?dl=0