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

[µo°Ý] ¦³ÃöExcel VBA°}¦C¨Ï¥Î¤è¦¡...

¦^´_ 3# VBALearner

¦p¦óª¾¹D±Æ¦W«e5¤j¼Æ­Èªº­ì©l¼ÐÅÒ(´N¬O­ì¥»ªº1~10±Æ§Ç³Q¥´¶Ã«á ¦p¦ó©I¥s)?

¥i¥H
1. ¨Ï¥Î2­Ó¤@ºû°}¦C¡A¤@­Ó¬ö¿ý­ì©l¼ÐÅÒ(©Î¶¶¦ì)¡A¤@­Ó¬ö¿ý¸ê®Æ°}¦C
2. ¨Ï¥Î2ºû°}¦C¡A¤@ºû¬ö¿ý­ì©l¼ÐÅÒ(©Î¶¶¦ì)¡A¥t¤@ºû¬ö¿ý¸ê®Æ°}¦C
3. ©Î­ì©l¸ê®Æ»P­ì©l¼ÐÅÒ¦X¨Ö¡A
¨Ò¦p  
1  33 ¦X¨Ö¬° 33001
2  11 ¦X¨Ö¬° 11002
3  44 ¦X¨Ö¬° 44003
±Æ§Ç«á¨ú¸ê®Æ«á3½X´N¬O­ì©l¼ÐÅÒ(©Î¶¶¦ì)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD