check checkbox value by position

Thanks a lot wamp that might actually make this a lot easier. Will try my best to get it working and post any results here.

Sincerely yours John

Well the work is partially done and I am very content with it so far.

Please Login or Register  to view this content.

It fills all my lines with nice little squares or hooks, depending on their state and always indicating their position.
However for the boxes in the columns H, I and J I was looking to implement something to make sure that at all times only one of them is checked. Originally I had some working code for my checkboxes that relied on the following:

Please Login or Register  to view this content.

That would rely on the Application.Caller to find out where it had to do its work, now that this is not valid any longer I tried to implement something along the lines of:

Please Login or Register  to view this content.

The only remaining question is, how do I make sure that this code is executed each time one of my cells changes its status?

Sincerely yours John

Not entirely convinced I follow, but try this:

Please Login or Register  to view this content.

If I get it correctely your code would delete all content of the three collumns and then just write one hook into the cell I just clicked, but what I want is to only overwrite the two corresponding cells with "z".
Basically changing from:
column 1|column 2|column 3
___°___|___x___|___° ___
___°___|___x___|___° ___
___°___|___x___|___° ___
to:
column 1|column 2|column 3
___°___|___x___|___° ___
___°___|___x___|___° ___
___x___|___°___|___° ___
with one click at (2,1)

So there should only be one tick in each row?

Correct, one tick each row, at lest between H, I and J while B can be whatever it wants to be

Try this:

Please Login or Register  to view this content.

Modified it a little bit to my liking and to what I want it to do and am now happy with the result:

Please Login or Register  to view this content.

Sincerely yours John