Checkbox to show 1 of 2 cells value

[directx]

Hello everyone,

I have a problem with controling CheckBoxes.

1st I want to forbid checking both of CheckBoxes, maybe like automaticly uncheck 1st box when I check 2nd.

2nd Since it is imposible to check both boxes in a same time, I want to in cell I3 show value of cell C2 if Checkbox 1 is checked, if Checkbox 2 is checked, I want to display value of Cell C4 in same I3 cell. Same thing goes for J3 and cells C3 and C5.



Is it posible?



Best Regards

 

[Eric W]

You can do that with VBA. However, I'd recommend looking into radio buttons instead of check boxes. If you set up 2 radio buttons with the same group, that only allows one of them to be selected at the same time. Then you can use ordinary worksheet functions in I3 and J3 to look at the value of the radio button, and display the values you want.

 

[ncrcnbl]

I've been told it's easier+safer to use the controls as intended, which means you want a pair of radio buttons here, in the same group:

Option Explicit

Private Sub OptionButton1_Click()
    updI3
End Sub

Private Sub OptionButton2_Click()
    updI3
End Sub

Private Sub updI3()
    If OptionButton1 Then
        Range("$I$3") = Range("$C$3").Value2
    ElseIf OptionButton2 Then
        Range("$I$3") = Range("$C$4").Value2
    End If
            
End Sub