Forms check box question – please help

[Blue Rain]

Apart from the check box background and font “fore” colour changes is it possible to change the inside colour of the check box itself? I refer to the inside of the box which is normally white and that has the black check mark symbol inside. Also can the check mark symbol be changed to another symbol or removed altogether?</SPAN>

That is when the check box is in the disabled state instead of having a white colour it has, lets say a patterned green colour, and when the check box is in the enabled state the patterned green turns to green without the check mark. Sort of to give an ON – OFF effect.</SPAN>

Can anyone provide a macro to achieve this?</SPAN>

Thank you.</SPAN>

PS I know very little on VBA.</SPAN>

 

[CalcSux78]

If you are using ActiveX checkboxes, you could set the value to Mixed giving it a patterned background inside the checkbox.

Sub changecolor()
ActiveSheet.Shapes.Range(Array("Check Box 2")).Select
With Selection
    .Value = xlMixed
End With
End Sub

Since the above code is working with an array, you could add multiple checkboxes within the array separated by a comma.

i.e. Array("Check Box 2", "Check Box 3")

 

[Blue Rain]

If you are using ActiveX checkboxes, you could set the value to Mixed giving it a patterned background inside the checkbox.

Sub changecolor()
ActiveSheet.Shapes.Range(Array("Check Box 2")).Select
With Selection
    .Value = xlMixed
End With
End Sub

Since the above code is working with an array, you could add multiple checkboxes within the array separated by a comma.

i.e. Array("Check Box 2", "Check Box 3")

Many thanks for your reply. It is an option which achieves part of what I am after and which did not cross my mind.</SPAN>

To me it’s strange why the check box checking region can not be addressed to change it’s colour. </SPAN>