- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 14
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-6
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2014-9-10 22:24 ½s¿è
luhpro ¤j¤j§A¦n §Ú·Q¥Î ....Interior.ColorIndex = x·í§@ÅÜ¼Æ ¨C·íµo²{¦P¤@Á`Ãþ¸ê®Æ«½Æ¨Ï¥Î ¬õ¦â ¥t ...
s13983037 µoªí©ó 2014-9-9 23:50
¤£«Øij.
Y§A·Q³o¼Ë¥Î,
1. Excel VBA ªº ColorIndex ªº¼ÆÈ¥»¨¨Ã¤£³W«ß,
(¬Ý°_¨Ó¨Ã¤£¹³¬ORGB²`²LÈÅܰʶqªº²Õ¦X,¦Ó¹³¬O©T©wªºªº¬YÓ¦âÈ»P§Ç¸¹ªº¹ïÀ³Ãö«Y, ©Ò¥H¤£®e©ö¥X²{§A©Òºc·Qªº¨ººØ®ÄªG)
¦³¥i¯à¥X²{¬Ý°_¨ÓÃC¦â®t¤£¦h,
¦ý¼ÆÈ«o¤£¦Pªº±¡§Î.
2. ¦³©³¦â»P¤å¦rÃC¦â®t²§¹L¤p(¬Æ¦Ü¬Û¦P)¾ÉP¤å¦r¤£©úÅ㪺°ÝÃD.
·íµM, ¦³Ó RGB ¨ç¼Æ¥i¥H¹F¦¨·Qnªº¦â½X²Õ¦X,
¨Ò¦p : [A1].Interior.Color=RGB(255,127,0)
¦ýÁÙ¬O·|¦³¤Wz 2. ©ÒÁ¿¨ìªº±¡§Î»Ýn¦Ò¼{.
§Ú´¿¸g¤]¦³Ãþ¦üªººc«ä,
´N¬O¥Î¤£¦PªºÁäȱa¤J¦P¤@Ó¤½¦¡,
¨Ó¦Û°Ê²£¥Í¤£¦PªºÀx¦s®æ©³¦â»P¤å¦rÃC¦â²Õ¦X,
´Á±æ¯à«Ü¤è«Kªº°Ï§O¤£¦P¸s²Õªº¸ê®Æ.(¹w´Á¶W¹L50¸s¥H¤W)
¦ýpºâµ²ªGÁ`¬O¤£¦p¹w´Á,
¦p©³¤U¹Ï§Î©Òªí²{¥X¨Óªº±¡§Î.
§Ú·Q¹L¤ñ¸û¥i¦æªº¤è¦¡¬O§Q¥ÎÃþ¦ü°}¦C¤§Ãþªºµ²ºcª½±µ³]¦nÀx¦s®æ©³¦â»P¤å¦rÃC¦â¨âªÌªº°t¹ï¦âÈ. |
|