- ©«¤l
- 32
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2011
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-13
- ³Ì«áµn¿ý
- 2014-7-8
|
[µ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 ?
ÁÂÁÂ |
|