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

[µo°Ý] ¦p¦ó§@¤@­Ó global event handler(¹³cell change, shape move event)

[µo°Ý] ¦p¦ó§@¤@­Ó global event handler(¹³cell change, shape move event)

¤p§Ì§Q¥Î excel §@ floorplan¡A
¥Îshape¨Ó¥Nªíª«Åé¤Î¤@¨Çcel lÀx¦s/Åã¥Ü shape.Top shape.Left
¤p§Ì·Q§@ªº¥\¯à¬O²¾°Ê shape ·|¦Û°Ê¥h§ó·s cell ªº Top ¤Î Left ªº­È¡A
¤Ï¤§§ïÅÜ cell value(Top, Left) ·|¦Û°Ê§ó·s shape ªº¦ì¸m¡C
´N§Úª¾¹Dªº¨C­Ó sheet ¸Ìªº code ·|¥i¥H¬Ý¨ì cell change event ,
¦ý§Ú§Æ±æ¥i¥H§â³o¨Ç handler subroutine ¼g¦b module ¸Ì¡A¦Ó¤£¥Î¨C­Ósheet¸Ì³£­n¥[¡C
¦AªÌ¡A¦n¹³¨S¦³¬Ý¨ì shape change event ?

ÁÂÁÂ

http://forum.twbts.com/viewthrea ... %26amp%3Btypeid%3D3
¦b½×¾Â§ä¨ì³o¤@½g¡A·Pı¤WÀ³¸Ó¥i¥H¥Î¤W¡A
¤£¹L¥Ø«e¸û¨S¦³®É¶¡¡A¥u¯à¤§«á¦A¨Ó¬ã¨s

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD