3 option boxes to linked cell-linked cell to be 1,2,3.

[Paula]

I have worksheets full of checkboxes grouped in 3s (Yes, No, N/A). They are
linked to a cel and it is 1,2,3. I have a formula attached to 1,2,3. The
problem is, on a worksheet instead of 1,2,3, a linked cell reads 4,5,6. I
have to have them all read 1,2,3 because I have a macro that defaults to 2.
I have removed checkboxes, group box, reset them, made them smaller, deleted
them, then rewrote them, all to no avail (these things have helped in the
past). Does nayone know the reason they do this and can tell me how to fix
it?

Thanks, Paula

 

[JLGWhiz]

I am not sure that I understand the problem, but Excel automatically assigns
index nujmbers to objects as they are added to a collection on a worksheet.
Although you might have 12 checkboxes grouped in threes in a frame, Excel
still sees them as Checkbox1 thru Checkbox12. Otherwise, it would be
difficult to know which Checkbox is being referred to for execution or
value.