关于Excel 2003中的Excel Events [英] About Excel Events in excel 2003

问题描述

在Excel 2003中，存在任何事件?与Cell_leave事件匹配

感谢您的答复..

In Excel 2003 any events are there???which matches with Cell_leave event

Thank U for ur replies..

推荐答案

您可以尝试使用selectionChange事件.

您可以评估哪个单元格具有当前焦点，并跟踪在当前单元格范围之前具有焦点的最后一个单元格范围.

You can try to use selectionChange event.

You can evaluate which cell has current focus and keep track of last cell range that had focus prior to the current cell range.

Private Sub Worksheet_SelectionChange(ByVal currentRange As Range)
Static lastRange As Range
    If Not lastRange Is Nothing Then
        If lastRange.Address = "

A

1" ' 运行代码 结束 如果 结束 如果 设置 lastRange = currentRange 结束 子

1" Then 'Run Code End If End If Set lastRange = currentRange End Sub

问候

Regards

这篇关于关于Excel 2003中的Excel Events的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！