本帖最后由 sgxb123431380 于 2013-11-14 08:23 编辑
看看是不是你要的,蓝字的地方是对范围的限定,我是给你限定到G6:Q6了,你可以自己再改位置
在ThisWorkbook中写入下面的代码
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
For i = 96 To 105
Application.OnKey "{" & i & "}"
Next i
If Selection.Row = 6 And Selection.Column > 6 And Selection.Column < 18 Then
For i = 96 To 105
Application.OnKey "{" & i & "}", "tz" & i - 96
Next i
End If
End Sub
新建一个Module1写入下面的代码
Public Sub tz0(): Call tz(0): End Sub
Public Sub tz1(): Call tz(1): End Sub
Public Sub tz2(): Call tz(2): End Sub
Public Sub tz3(): Call tz(3): End Sub
Public Sub tz4(): Call tz(4): End Sub
Public Sub tz5(): Call tz(5): End Sub
Public Sub tz6(): Call tz(6): End Sub
Public Sub tz7(): Call tz(7): End Sub
Public Sub tz8(): Call tz(8): End Sub
Public Sub tz9(): Call tz(9): End Sub
Public Function tz(n)
ActiveCell = n
If Cells(ActiveCell.Row, ActiveCell.Column - 1) = "" Then Cells(ActiveCell.Row, ActiveCell.Column - 1) = "$"
Cells(ActiveCell.Row, ActiveCell.Column + 1).Select
End Function