- ©«¤l
- 65
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 120
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-15
- ³Ì«áµn¿ý
- 2010-7-16
|
¦^´_ 5# PD961A
¤p§Ì§Ú¥Î¤ñ¸û²Âªº§@ªk¡A¤£¹L©O¬O¥i¥H¹F¨ì±znªº®ÄªG´N¬O¤F
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
For Each a In Range(Me.[a2], Me.[h17])
Select Case a
Case Me.[a1]
a.Interior.ColorIndex = 3
Case Me.[b1]
a.Interior.ColorIndex = 4
Case Me.[c1]
a.Interior.ColorIndex = 5
Case Me.[d1]
a.Interior.ColorIndex = 6
Case Me.[e1]
a.Interior.ColorIndex = 7
Case Me.[f1]
a.Interior.ColorIndex = 8
Case Me.[g1]
a.Interior.ColorIndex = 9
Case Me.[h1]
a.Interior.ColorIndex = 10
Case Else
a.Interior.Pattern = xlNone
End Select
Next
End Sub |
|