Checkbox display cell data realtime

[Feongxd]

hi, i need help with this

I have a checkbox "aa" when check, it will display in cell F5 then value in B2
But when i change B2 without unchecking "aa" Cell F5 still shows the old value.
Im using checkbox activeX.

Can it be done as when i change a new value into B2, F5 will auto update without having to uncheck and check the box again.

Private Sub CheckBox1_Click()
Set ws = ThisWorkbook
Set aa = CheckBox1
    If aa.Value = True Then Range("F5").Value = ws.Sheets("Sheet2").Range("B2")
    If aa.Value = False Then Range("F5").Value = Null
End Sub

 

[RoryA]

Welcome to the forum.

You could put a formula into the cell instead of a value:

Range("F5").Formula = "=Sheet2!B2"

rather than this:

Range("F5").Value = ws.Sheets("Sheet2").Range("B2")

 

[Feongxd]

Omg,
It works!
thank you so much i've spend hours thinking how to do it.

 

[RoryA]

Glad to help.