Excel Error: 28 Out of Stack space

[AinMn]

Hi, I am a new excel user and vb program. I managed to code my excel worksheet based on my prefered criteria/condition/formulas. But i am experiencing this error:28 out of stack problem. Can someone help me with this as i have already google for every solution, but still can fix it.

here are the codes i have so far.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

And attach is the sample excel i'm working on..

[Leith Ross]

Hello AinMn,

This a common mistake made in VBA. The Worksheet_Change and Worksheet_SelectionChange events are the culprits. You must disable events whenever your code change the contents of a cell or changes the location of the ActiveCell inside either of these events. If you don't then you will call the event again, and again, ad nauseam until there is no more stack space.

Please Login or Register  to view this content.