- Public Sub RangeSelection(sender As Object,e As SpreadsheetGear.Windows.Forms.RangeSelectionChangedEventArgs)
- AW.WorkbookSet.GetLock()
- Dim Range As IRange = AW.ActiveWorksheet.Range
- Dim RngA As IRange = e.RangeSelection.Intersect(Range("SelectArea_A"))
- Dim RngB As IRange = e.RangeSelection.Intersect(Range("SelectArea_B"))
- If Not RngA Is Nothing Then
- For Each Target As IRange In RngA
- Target.Value = IIf(Target.Value = "√", "", "√")
- Next
- End If
- If Not RngB Is Nothing Then
- For Each Target As IRange In RngB
- IF Target.Offset(0,-1).Value = "赊账" Then
- Target.Value = IIf(Target.Value = "√", "", "√")
- Else:
- Target.Value = IIf(Target.Value = "", "", "")
- End If
- Next
- End If
- AW.WorkbookSet.ReleaseLock()
- End Sub'单元格选择后执行的事件
复制代码
SelectArea_A,SelectArea_B是两个打勾的区域,可以替换为你自己的区域别名
|
|
hessen