ªð¦^¦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

¸Õ Run ¤F¤j¤jªºÀɮסA¦³´X­Ó°ÝÃD
1¿é¤JÃöÁä¦r«á¡A«ö¤U Enter¡A¥u¯àIJµo¤@¦¸¡A±NÀx¦s®æ¦ì§}­«·s¿ï¦^$D$3¡A¦A«ö Enter ´N¨S¦³§@¥Î¤F¡A«ö«ö¶s¤~¯àIJµo¡C
2¦pªG¦¹®É«öDeleteÁä²M°£ $D$3ÃöÁä¦r¡A¤]·|IJµo¡C
3¦pªG$D$3¨S¿é¤J¥ô¦óÃöÁä¦r¡A«ö«ö¶s¤´µM·|IJµo¡A«ö Enter µL§@¥Î¡C

¥H¤W²Ä2,3ÂI¡A¦ü¥G¤£¤Ó¥¿±`
§Ú§Æ±æ$D$3³Q¿ï¨ú«á¡A­YµL¿é¤J¥ô¦óÃöÁä¦r´N«ö Enter¶i¦æ¬d¸ß¡A¤£­n¦³¥ô¦ó°Ê§@¡A©ÎªÌ¥X²{¤@­Ó´£¥Ü¡C
¨ä¹ê§Ú·Q­nªº®ÄªG´N¬OÃþ¦ü¤@¯ë¥«°â³nÅ骺¬d¸ß¥\¯à¡A¥u¤£¹LÃöÁä¦r¿é¤J®Ø´«¦¨Àx¦s®æ$D$3¡AÁä½L Enter ©M¬d¸ß«ö¶s°µ¤@­ÓµJÂI³sµ²¡C
Jess

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

¦^´_ 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

¨ä¹ê§Ú­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

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

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD