Run TIme Error 28: Out of Stack Space

[smciesl2]

Hi! Hoping someone can help me understand where this error is coming from. I have a nested macro set up to run a macro off from a drop down list selection. This is the first time i have put something like this together, so i am assuming the combination of the two macro's is causing the problem. I just dont know how to fix it. Any help appreciated!!

here is the code that works with the drop down list:

Please Login or Register  to view this content.

here is the macro it calls on:

Please Login or Register  to view this content.

any questions, let me know i will do my best to answer them.

[romperstomper]

You are calling the change event recursively due to the changes made by the called routine. Try this:

Please Login or Register  to view this content.

[smciesl2]

GENIUS! Thank you so much. Works like a charm now