How to capture "Clear Contents" Excel right click context menu option.

I want to run a piece of code when user right clicks on a cell and selects
"Clear Contents" context menu option.

Dev,

Put the following code in the ThisWorkbook module.

Private WithEvents Ctrl As CommandBarButton

Private Sub Ctrl_Click(ByVal Ctrl As Office.CommandBarButton,
CancelDefault As Boolean)
MsgBox "Hello World"
End Sub

Private Sub Workbook_Open()
Set Ctrl = Application.CommandBars.FindControl(ID:=3125)
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Dev" wrote in message
...
How to capture "Clear Contents" Excel right click context menu
option.

I want to run a piece of code when user right clicks on a cell
and selects
"Clear Contents" context menu option.

Thanks Chip - this worked great!!.

Do you know the ID for "Insert Copied Cells..."?

"Chip Pearson" wrote:

Dev,

Put the following code in the ThisWorkbook module.

Private WithEvents Ctrl As CommandBarButton

Private Sub Ctrl_Click(ByVal Ctrl As Office.CommandBarButton,
CancelDefault As Boolean)
MsgBox "Hello World"
End Sub

Private Sub Workbook_Open()
Set Ctrl = Application.CommandBars.FindControl(ID:=3125)
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Dev" wrote in message
...
How to capture "Clear Contents" Excel right click context menu
option.

I want to run a piece of code when user right clicks on a cell
and selects
"Clear Contents" context menu option.

I think I got it... it's 3181

"Dev" wrote:

Thanks Chip - this worked great!!.

Do you know the ID for "Insert Copied Cells..."?

"Chip Pearson" wrote:

Dev,

Put the following code in the ThisWorkbook module.

Private WithEvents Ctrl As CommandBarButton

Private Sub Ctrl_Click(ByVal Ctrl As Office.CommandBarButton,
CancelDefault As Boolean)
MsgBox "Hello World"
End Sub

Private Sub Workbook_Open()
Set Ctrl = Application.CommandBars.FindControl(ID:=3125)
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Dev" wrote in message
...
How to capture "Clear Contents" Excel right click context menu
option.

I want to run a piece of code when user right clicks on a cell
and selects
"Clear Contents" context menu option.