|
按照你的意思给写了一下,用于sheet1表:- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim arr
- arr = Array("√", "☆", "φ", "○", "#", "~", "△", "*")
- If Target.Count > 1 Then Exit Sub
- If Not Intersect(Range("c7:bl26"), Target) Is Nothing Then
- Application.EnableEvents = False
- If Target > 0 And Target < 9 Then
- Target = arr(Target - 1)
- Else
- MsgBox "输入错误!"
- Target.ClearContents
- End If
- Application.EnableEvents = True
- End If
- End Sub
复制代码 |
|