Can you write a loop for Worksheet change event?

[brently]

I have an if statement that is too long in the worksheet change event (Compile Error: Procedure too large). I wrote it all out instead of looping or calling outside procedures
Question1 : Is it possible to write a loop to check the target cell based on cell name?
Question 2: I broke up the code into section (0-5) but when i call the outside procedure using "If Target =" the target function doesnt seem to work unless its in the Worksheet module
This survey has 95 questions and each question has an answer field, score field, and must signal a sync if any data in that question is changed.
Here are the first 9 questions

Please Login or Register  to view this content.

[nathansav]

I would do it something like

Please Login or Register  to view this content.

[nathansav]

sorry like

Please Login or Register  to view this content.

[nathansav]

Last one, did it without being in excel.

Please Login or Register  to view this content.

[brently]

ah cool thanks! i knew there was an easier way! just posting the final code as there was still one mispelling

Please Login or Register  to view this content.