- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 239
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-4
|
¦^´_ 3# landylin
Åܧó¤uªí¯Á¤Þ¼ÐÅÒÃC¦â¥²¶·¨Ï¥ÎVBA»²§U
n¹F¨ì¦Û°Ê¤Æn¬Ý§AÁ`ªíE6:E8¸ê®Æ¨ú±o¤è¦¡¬°¦ó?
°t¦X¨Æ¥óµ{§Ç¨ÓIJµoVBA
¨Ò¦p:E6:E8¬O¤â°Ê¿é¤J
Á`ªí¤u§@ªí¼Ò²Õ¿é¤J- Private Sub Worksheet_Change(ByVal Target As Range)
- If Intersect(Target, [E6:E8]) Is Nothing Then Exit Sub
- For Each a In [E6:E8]
- k = Application.Lookup(a, Array(0, 0.9, 1), Array(3, 6, 4))
- a.Interior.ColorIndex = k
- Sheets(Right(a.Offset(, -1), 1)).Tab.ColorIndex = k
- Next
- End Sub
½Æ»s¥N½X Y¬°¤½¦¡¨ú±o- Private Sub Worksheet_Calculate()
- For Each a In [E6:E8]
- k = Application.Lookup(a, Array(0, 0.9, 1), Array(3, 6, 4))
- a.Interior.ColorIndex = k
- Sheets(Right(a.Offset(, -1), 1)).Tab.ColorIndex = k
- Next
- End Sub
½Æ»s¥N½X |
|