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

Excel VBA °»´úShape selectªº°ÝÃD

Excel VBA °»´úShape selectªº°ÝÃD

°ÝÃD¬O³o¼Ëªº
§Ú¦b§Úªºexcelªí¸Ì´¡¤J¤@­Ó¥D¾÷ªO¹Ï­±,
¦P®É¤W­±»Ý­n©Ô¹Ï§Î½u¼Ð¥Ü©Ò¦³¤¸¥ó, ¥Ñ©ó ¹ê¦b¬O¹s¥ó¤Ó¦h¤F,
½u(shape)©Ôªº«ÜÂø¶Ã, ©Ò¥H·Q»¡¦³¨S¦³¥i¯à°ÊºA°»´ú¨ì§Ú¿ï¨ì­þ­Ósahape(½u), ´NÅܦâ©O?

·N«ä´N¬O §Ú©Ò¦³ªº½u³£¬O¬õ¦âªº
¥u·í§Ú·í¤UÂIÀ»¨Ã¿ï¾Üªºshape ¤~Åܦ¨¶À¦â½u
¦Ó·í§Ú¿ï¾Ü¥t¥~¤@±ø½u®É, ¤§«eªº½u¤SÅܦ^¬õ¦â, ´«·s¿ï¾ÜªºÅܦ¨¶À¦â...

½Ð°Ý³o¼Ë¦³¥i¯à¶Ü?

§Ú¦Û¤v¬O·|¼gÅܦâ¨S°ÝÃD,
¦ý¬O§Ú¥u¬Ý¨ìworksheet_change ³o­Ósub ,
³o­Ósub¬O°w¹ïÀx¦s®æ¦³Åܰʮɤ~·|°Ê§@.............¸ò§Ú­n¨Dªº°»´ú¨ìshape selectÅܲ§®É¤~°µ°Ê§@ ¤£¤@¼Ë

¦³°ª¤â¥i¥HÀ°¦£¤@¤U¶Ü? ÁÂÁ®@!!

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD