reset the values of a range

I am looking for VB code to solve a quite simple problem:

I have two cells with drop-down list, say C5 and C6. C6 is dependent on C5, which means when you change the value in C5, the list of options in C6 will change as well. The job I want the code to do is when I change C5, it should set C6 default value as " ", and the value in range D5:H5 as False. And when I change value in C6, C5 remains unchanged, the value in range D5:H5 should be all set as False too.

The code I manged to come up with is shown below. But when I run it, excel got an error msg saying something like stack overflow. Not sure where goes wrong. Any help will be appreciated. Thanks.

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.