000Steve000
IS-IT--Management
I would like to run a macro to check the contents of a cell when a user chages its colour. The colour change does not trigger the worksheet change event. Can anyone help?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Private Sub Worksheet_BeforeRightClick(ByVal Target As Excel.Range, Cancel As Boolean)
x = MsgBox("Flag/Color this cell?", vbYesNo)
If x = 6 Then ' user chose Yes
' Do your thing here
Cancel = True ' Prevents right-click menu
Else
' Do nothing
End If
End Sub