VBA Code to change cell from True to False and vice versa

[tlc53]

Hi,

I'm not sure how to go about writing this VBA code. Can someone help me please?

I would like cell M10 to change from True to False and False to True when the VBA Code is run.

So if M10 = True return False, if M10 = False return True

Thank you!!

 

[juddaaaa]

Try this

Range("M10") = Not Range("M10")

 

[alansidman]

Option Explicit

Sub switch()
    If Range("M10") = True Then
        Range("M10") = False
    Else: Range("M10") = True
    End If
End Sub

 

[tlc53]

Option Explicit

Sub switch()
    If Range("M10") = True Then
        Range("M10") = False
    Else: Range("M10") = True
    End If
End Sub

Perfect! Thank you