Is it possible to group a set of ActiveX Check boxes and then name that group (All of the check boxes have their own set name)
Original Issue
I'd been having issues with ActiveX check boxes not moving correctly when the cell they are over are hidden (They were set to shape and size with cells), so in the end I thought I'll ditch them for standard form controls as they didn't seem to have the glitch, and rather than have size and shape with cells I'd use code to make visible/Invisible when needed.
New Issue
I'm now trying to add in a few more features to the check boxes so that they have a cell change value and as I need only one cell ticked at a time, if the cell clicked = true then clear all the others in the row.
I've tried doing this in the standard form control but it doesn't seem to recognize the names of the other check boxes or it's own name in the If .Value = True. Is there anyway to have this work?
I tried on a seperate copy redoing them all as ActiveX, but I can't seem to group them, so for the visible/Invis' code, that will be an extra 50 odd lines of code that I'd rather avoid.
In shot, can you name a group of named ActiveX check boxes, or can you get the standard form check boxes to understand their own name and if they are true or not?
Best regards,
~Will S
Original Issue
I'd been having issues with ActiveX check boxes not moving correctly when the cell they are over are hidden (They were set to shape and size with cells), so in the end I thought I'll ditch them for standard form controls as they didn't seem to have the glitch, and rather than have size and shape with cells I'd use code to make visible/Invisible when needed.
New Issue
I'm now trying to add in a few more features to the check boxes so that they have a cell change value and as I need only one cell ticked at a time, if the cell clicked = true then clear all the others in the row.
I've tried doing this in the standard form control but it doesn't seem to recognize the names of the other check boxes or it's own name in the If .Value = True. Is there anyway to have this work?
I tried on a seperate copy redoing them all as ActiveX, but I can't seem to group them, so for the visible/Invis' code, that will be an extra 50 odd lines of code that I'd rather avoid.
In shot, can you name a group of named ActiveX check boxes, or can you get the standard form check boxes to understand their own name and if they are true or not?
Best regards,
~Will S
