|
- <P>Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
- Target.Value = Mid(Target, 1, 3) & " " & Mid(Target, 4, 4) & " " & Mid(Target, 8, 4)</P>
- <P>Target.Characters(Start:=5, Length:=4).Font.ColorIndex = 5
- Target.Characters(Start:=10, Length:=4).Font.ColorIndex = 3
- End Sub
- </P>
复制代码 可以了,楼主记得给最佳哦。呵呵 |
|