Worksheet_SelectionChange - So.... what am I doing wrong...

[SymphonyTomorrow]

Hi all,

I would like to run a macro when cells are clicked. I've placed my code into the worksheet level, but I'm not getting any activity. I don't know if I need to "turn it on" somehow or what exactly...

Here's a couple versions of what I have, but in both cases when I switch back to the worksheet, Nothing happens. I'm trying to do a yes no questionnaire without buttons or data validation drop downs. You click the "Yes" cell, and it puts "Yes" in the reference column and changes the color of the clicked cell while "greying out" the "No" cell. And if you then go click on the "No" cell it reverses it.

Furthermore, I would like to know how to apply this across several ranges. I'm terrible with this sort of thing in VBA, but I could make a formula in no time.

The only difference between the versions is one calls another function, but I don't see why it can't just do the work at the event.

Ver 1

Please Login or Register  to view this content.

Ver 2

Please Login or Register  to view this content.

[SymphonyTomorrow]

Ok, the fundamental question I was asking I fixed and I am an idiot. I was in design mode. Sorry.


But I'm still trying to make this work as we speak, so if I've done something wrong on my code, please let me know.

[Blokeman]

Is this what you're after? This is only for 1 row.

Please Login or Register  to view this content.

[SymphonyTomorrow]

Is this what you're after? This is only for 1 row.

Please Login or Register  to view this content.

Thanks for the response Blokeman. It took some doing, but I actually did get the whole thing figured out yesterday, for all the cells. My code is below. I focused on actions off of the active cell, the one the user has clicked, and used Offsets to change things nearby.

Please Login or Register  to view this content.