Multiple worksheet change events error

Hi All,

I'm having trouble to combining 10+ change events. I'm very new to VBA and I'm not able to find a solution.

What I'm trying to do is if user enters a value more than 2 for a question then he is been given option to answer to sub questions which are directly below. So there are 10 such questions with each question having 4 sub-questions which are shown or hidden based on the user input(i.e value in cell >2 or not)

Please find below the code:

Please Login or Register  to view this content.

And so on till 10 criterias



When I run it I get an error " Ambiguous name:Worksheet_Change".


Please help me with this dilemma.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Ok.

You can only have one change event per worksheet.

The trick is to use the one event efficiently.

I will demonstrate:

Please Login or Register  to view this content.

To see how this work

Open your Macro

Click on the Grey Bar on the left hand side of a macro line. prefferable:

Please Login or Register  to view this content.

A Brown Circle will appear and the line will be highlighted in Brown. You have inserted a break point and your macro will stop at that point.

You can step through the macro line by line by pressing f8 or you can resume the macro by pressing f5.

The beauty is while your macro is stooped you can click on view in the VBA mobule and then local window.

This will allow you to see all your variables and arrays and their contents.

With a bit of investigation you will see why I am using Pos -1 in the line

Please Login or Register  to view this content.