Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)Set Target = ActiveCell
Cancel = True
With Target
If .Column = 6 Then
Cancel = True
If .Comment Is Nothing Then
.AddComment
.Comment.Shape.Width = 50.5
.Comment.Shape.Height = 10.75
End If
SendKeys "%im"
End If
If .Column = 8 Then
Cancel = True
If .Comment Is Nothing Then
.AddComment
.Comment.Shape.Width = 110.5
.Comment.Shape.Height = 15.75
End If
SendKeys "%im"
End If
End With
End Sub