Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) On Error Resume Next Dim 型号 As String Dim 描述 As String Dim 单价 As Currency Cancel = True If Target.Column = 1 Then 型号 = Target.Value 描述 = Target.Offset(0, 1).Value 单价 = CCur(Target.Offset(0, 3).Value) ElseIf Target.Column = 2 Then 型号 = Target.Offset(0, -1).Value 描述 = Target.Value 单价 = CCur(Target.Offset(0, 2).Value) End If AddToQutation Me.Name, 型号, 描述, 单价End Sub