Cell change and event trigger from worksheet calculate

[Neilsinc]

I have the file below. What I need this file to do is display a message box when cell A1 changes to a certain value. It works ok with clicking the boxes, but can't work out how to trigger an event based on the cell A1 calculation changing.

Thanks in advance

https://www.dropbox.com/s/y4cbpxlz9tfia64/Using Worksheet_Calculate For Checkbox.xlsm

 

[Debraj]

Hi Neilsinc

Welcome to the forum..

Trigger an event.. when cell value changes by some external reference.. you have to use.. CALCULATE event..
What you are already doing..

Just add the reference.. with the desired Certain Value.. something like this..

Private Sub Worksheet_Calculate()
    If [a1] = 2 Then
        MsgBox "Is this what you are looking for!!!"
    End If
End Sub