ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] Åý¹«¼Ð©Ò¿ï¾Üªº¦æ¦C¥i¥H°ª«G¡A«oµLªk¨Ï¥Î Ctrl+Z ¥\¯à

[µo°Ý] Åý¹«¼Ð©Ò¿ï¾Üªº¦æ¦C¥i¥H°ª«G¡A«oµLªk¨Ï¥Î Ctrl+Z ¥\¯à

½Ð°Ý¦U¦ì«e½ú¡A§Ú¬O¥Î¤U­±³oµ{¦¡½X¡AÅý§Ú¹«¼Ð©Ò¿ï¾Üªº¦æ¦C¥i¥H°ª«G¡AÅý¸ê®Æ§ó®e©öÃѧO
¦ý¬O­n½s¿è¸ê®Æ®É Ctrl+Z µLªk¨Ï¥Î¡A«D±`§xÂZ¡A½Ð°Ý¦³¤èªk¥i¥H¨Ï¥Î Ctrl+Z ¡H

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Columns().Interior.ColorIndex = 0

    x = ActiveCell.Column

    Columns(x).Interior.ColorIndex = 35

    y = ActiveCell.Row

    Rows(y).Interior.ColorIndex = 35

End Sub

¦^´_ 1# leondavinci727
´Nµ{¦¡½X¬Ý¨Ó»PCTRL+Z¥\¯àµLÃö
§A¦³¨ä¥L¦a¤è¨Ï¥ÎONKEYS«ü¥O±NCtrl+Z µ¹§R°£¶Ü?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

¨S¦³¨Ï¥Î§Oªºµ{¦¡½X¤]

¼t°Ó¸ê®Æ.zip (15.76 KB)

TOP

¦^´_ 3# leondavinci727
°õ¦æªºµ{¦¡¤¤¦³­×§ïÀx¦s®æªº®æ¦¡,¤º®e,·|¾É­PµLªk¨Ï¥Î Ctrl+Z ¥\¯à
¥i°Ñ¦Ò ¸ê®Æ¬d¸ß
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# GBKEE

ÁÂÁÂ2¦ì¤j¤jªº¦^ÂÐ ¤p§Ì¥h°µ°µ¥\½Ò «D±`·PÁ¡I

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD