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

[µo°Ý] ¥H Enter ´À¥N«ö¶s

[µo°Ý] ¥H Enter ´À¥N«ö¶s

­ìµ{¦¡¬O§Ú¦bD3¿é¤J¬d¸ß¤å¦r«á(¤£·Q¥ÎTextBoxª«¥ó)¡A«ö«ö¶s¥i¥H¶i¦æ¬d¸ß¡A¦ý²{¦b§Æ±æ«öÁä½L Enter ¤]¥i½Õ¥ÎCommandButton1ªº¬d¸ß¥\¯à¡A¸Ó¦p¦ó°µ©O?
¬¡­¶Ã¯1.rar (10.14 KB)
Jess

·PÁ¨â¦ì¤j¤jªº«ü¾É¡C
Jess

TOP

enterIJµo v3.zip (20.07 KB) ¦^´_ 10# jesscc

3¸ò4 ª±ª±¬Ý
    ¨S©Û¤F ³Ñ¤U¬Ý¦³¨S¦³¤j¤j¯àÀ°§A= =

TOP

¨ä¹ê§Ú­nªº®ÄªG²³æªí¹F´N¬O³o¼Ë
CommandButton1 --> Click --> IJµo(¥u­n[D3]<>""¡A¤£½×Àx¦s®æªº¿ï¨úµo¥Í¥ô¦óÅܤÆ)
Áä½L Enter --> Click --> IJµo(¥u­n[D3]<>""¡A¤£½×Àx¦s®æªº¿ï¨úµo¥Í¥ô¦óÅܤÆ)
©Ò¥H Áä½L Enter = CommandButton1

S¤jªºV1ª©¥»¤ñ¸û¯à¹ïÀ³§Ú­nªº®ÄªG¡A¦]¬°§Ú¬d¹L¤@¨ÇÃþ¦ü key code=13 ªº¼gªk¡A¦ü¥G¥i¥H§âµJÂI¹ïÀ³¨ìÁä½LENTER¤W¡A©Ò¥H«ä¸ô¤@ª½´Â³o¤è¦Vµo®i¡C
Jess

TOP

¦^´_ 8# jesscc


    enterIJµo v2.zip (15.88 KB)
¦Û°ÊIJµo(2)¸Õ¸Õ ¦]¬°§Aªº»Ý¨D »P§A­ì¥ýªº¸ÑÄÀ¦³ÂI¼Ò½k
§Ú¥u¯à¥Î²qªº

TOP

¦^´_ 7# Andy2483

A¤j¡A§ÚÀ³¸Ó³o¼Ë±Ô­z
¿é¤JÃöÁä¦r«á¡A¨S¦³¥ß¨è«ö Enter ¦Ó¬O¥Î·Æ¹«ÂI¿ï[D3]¥H¥~¥ô·NÀx¦s®æ¡A¦¹®É·|¦³¤@¦¸¦]·Æ¹«ÂIÀ»ªºÄ²µo¡A¦ý³o¦¸Ä²µo¤§«áÁä½L Enter ´N¨S§@¥Î¤F¡C
©Ò¥H¥Ø«eªºµ{¦¡¬O¿é¤JÃöÁä¦r«á¡A¥²¶·«ö Enter ¤~·|¦³¤@¦¸EnterIJµo(¦ý³o­ÓEnterIJµo¨Ã¤£¬O¦]¬°³sµ²¤F¬d¸ß«ö¶s¡A¦]¬°¤£ºÞ·Æ¹«ÂI¦b­þ¸Ì¡A¬d¸ß«ö¶s¬OÀH®É¥iIJµoªº)
Jess

TOP

¦^´_ 6# jesscc

ÁÂÁÂS¤j¡C¸Õ Run «á·Pı¥\¯à¬O§Ú·Q­nªº¡A¦ý¬O¿é¤JÃöÁä¦r«á¡A¥Î·Æ¹«ÂI¿ï[D3]¥H¥~¥ô·NÀx¦s®æ¡A³o®ÉÁä½L Enter ´N¨S§@¥Î¤F¡AÃÒ©úÁä½L Enter ©M¬d¸ß«ö¶s¨S¹F¦¨µJÂI³sµ²¡A¤£ª¾³o¬O¤£¬OWorksheet_SelectionChangeIJµoªºµw¶Ë¡C
ÁÂÁÂA¤j¡C¿é¤JÃöÁä¦r«á¡A¥Î·Æ¹«ÂI¿ï¥ô·NÀx¦s®æ³£·|IJµo¡AÁä½L Enter ©M¬d¸ß«ö¶s¨S¹F¦¨µJÂI³sµ²¡C
    ¨â¬q¬õ¦â¦r¬O¤£¬O¥Ù¬Þ¤F? ÁÙ¬O ¨ä¥L·N«ä?
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

ÁÂÁÂS¤j¡C¸Õ Run «á·Pı¥\¯à¬O§Ú·Q­nªº¡A¦ý¬O¿é¤JÃöÁä¦r«á¡A¥Î·Æ¹«ÂI¿ï[D3]¥H¥~¥ô·NÀx¦s®æ¡A³o®ÉÁä½L Enter ´N¨S§@¥Î¤F¡AÃÒ©úÁä½L Enter ©M¬d¸ß«ö¶s¨S¹F¦¨µJÂI³sµ²¡A¤£ª¾³o¬O¤£¬OWorksheet_SelectionChangeIJµoªºµw¶Ë¡C
ÁÂÁÂA¤j¡C¿é¤JÃöÁä¦r«á¡A¥Î·Æ¹«ÂI¿ï¥ô·NÀx¦s®æ³£·|IJµo¡AÁä½L Enter ©M¬d¸ß«ö¶s¨S¹F¦¨µJÂI³sµ²¡C
Jess

TOP

¿é¤JÀx¦s®æIJµo.zip (15.39 KB) ¦^´_ 1# jesscc
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2021-8-18 14:04 ½s¿è

enterIJµo v1.zip (13.83 KB)

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD