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

[µo°Ý] SpinButton ª«¥ó

[µo°Ý] SpinButton ª«¥ó

ActiveX±±¨î¶µ¸Ìªº SpinButton ª«¥ó¡A¨ä¤¤ LinkedCell ÄÝ©Ê¡A¥u¯à³sµ²¤@­ÓÀx¦s®æ¶i¦æÅÜ°Ê¡C
¦pªG±qA1¨ìA10³£¦³¼Æ­È¶·½Õ¾ãÅÜ°Ê¡A¨º´N¥²¶·«Ø¥ß10­Ó SpinButton ª«¥ó¡A¥h¤À§O½Õ¾ã³o10­ÓÀx¦s®æªº­È¡C
¦³¨S¦³¿ìªk¡A¥u«Ø¥ß¤@­Ó SpinButton ª«¥ó¡AµM«á°w¹ïA1¨ìA10¤§¤¤³Q¿ï¨úªºÀx¦s®æ¡A¶i¦æ½Õ¾ã¡C¤]´N¬O»¡¥¦ªº LinkedCell ÄݩʬO¨Ì·Ó³Q¿ï¨úªºÀx¦s®æ°µ°ÊºA§ïÅÜ¡C
Jess

¦^´_ 1# jesscc


    ³o­Ó¥i¥H¥[¨Ç¥N½X
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 2# kimbal


    ÁÂÁÂK¤j¡C
§Ú¬Ý¤F¤@¤U»¡©úÀÉ¡A¤~ª¾¹D­ì¨ÓÁÙ¦³³oºØ¥Îªk¡A¥i¬O§Ú¦³­ÓºÃ°Ý¡ADown©MUp¤£¯à¼g¦b¤@­ÓSubùضÜ?³o¼Ë·Pı¤ñ¸ûºë²¡C
Jess

TOP

Up/Down ¬O¤º«Øªº¥\¯à,¥u¯à§â¨â­ÓSUB³s¦b¤@°_.....

Private sub SpinButton1_SpinDown()
        call sbchange(-1)
end sub
Private sub SpinButton1_SpinUp()
        call sbchange(1)
end sub
Private sub sbchange(c as integer)
        activecell.value = activecell.value + c
end sub
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 4# kimbal


    ¤F¸Ñ¤F¡A¤S¦h¾Ç¤F¤@­Ó¥Îªk¡AÁÂÁÂK¤j!
Jess

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD