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

[µo°Ý] VBA¤¤§Ö³t«Ø³]©w

[µo°Ý] VBA¤¤§Ö³t«Ø³]©w

½Ð±Ð¦U¦ì!!
¤p§Ì³]¤F¤@­Ó§Ö³tÁä¥Î¨Ó§Ö³t¶}±Ò¦Û­qªí³æ
·Q½Ð±Ð ªí³æ¶}±Ò«á ¥i¥H³]©w¥ÎESCÁä¨ÓÃö³¬ªí³æ¶Ü?

ÁÂÁ¦U¦ì!

¥»©«³Ì«á¥Ñ bobomi ©ó 2015-4-10 15:22 ½s¿è

https://msdn.microsoft.com/zh-tw/library/office/ff197461.aspx

TOP

¦^´_ 2# bobomi

·PÁ¦^ÂÐ ¤w¸Ñ¨M

TOP

¦^´_ 2# bobomi


    ¦¹¤èªk¥i¥H«ü©w·Æ¹«ªººu½ü¶Ü?¦pªG¦³ªº¸Ü¥i§_´£¨Ñµ{¦¡½X?§Ú¦b¦¹Page¤W¨S¦³¬Ý¨ì

·Qª¾¹D¦³¨S¦³¤èªk¥i¥H¥Î·Æ¹«ªººu½ü¨Óºu°ÊUserFormªºListBox
PKKO

TOP

¥»©«³Ì«á¥Ñ minture3 ©ó 2015-4-16 17:27 ½s¿è

¦^´_ 4# PKKO

Sorry ¥Ø«eÁÙ¨S¦³¬ã¨s¨ì·Æ¹«ºu½ü!!

TOP

¦^´_  bobomi


    ¦¹¤èªk¥i¥H«ü©w·Æ¹«ªººu½ü¶Ü?¦pªG¦³ªº¸Ü¥i§_´£¨Ñµ{¦¡½X?§Ú¦b¦¹Page¤W¨S¦³¬Ý¨ì

·Q ...
PKKO µoªí©ó 2015-4-16 12:08


Application.OnKey ¥u¹ï keyboard ¦³®Ä
mouse scroll ­n¥Î api ¥h®·®»

§Aªº excel ¬O 32bit ÁÙ¬O 64bit ??

TOP

¦^´_ 6# bobomi
¨ä¹ê¤W¦¸ªº°ÝÃD¥u¬O­è¦n§ä¨ì¥t¤@­Ó¸Ñ¨M¤è¦¡
¤§«e§Ú¤]¥Î¹L³o­ÓApplication.OnKey

¤£¹L³o­Óµ{¦¡½XÀ³¸Ó­n©ñ¦b­þ¸Ì?

'Application.OnKey "^Q", "¨t²Îµn¤J"
'Application.OnKey "^K", "¯Á¤Þ"

TOP

¦^´_ 6# bobomi


    32¡B64 ¦ì¤¸ªº¹q¸£³£¦³¥i¯à·|¥Î¨ì­C,¦ý§Ú¥Ø«e´ú¸Õ¥Îªº¹q¸£¬O64¦ì¤¸ªº!
PKKO

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD