ç¨VBAè¯è¯å§ï¼é¦å ç¡®ä¿ä½ çå·¥ä½èä¸æè³å°ä¸¤ä¸ªå·¥ä½è¡¨(sheet)ï¼ç¶åALT+F11ï¼æ°å»ºä¸ä¸ªç¨æ·çªä½ï¼ç¨é»è®¤å称ï¼userform1ï¼ææ¾ä¸¤ä¸ªæ ç¾æ§ä»¶ï¼ä¸¤ä¸ªææ¬æ¡æ§ä»¶ï¼ä¸ä¸ªæé®æ§ä»¶ãå¨âThisWorkbook"ä¸åå»ï¼å¨å³è¾¹è¾å ¥å¦ä¸ä»£ç ï¼
Private Sub Workbook_Open()ç¶ååå»æé®æ§ä»¶ï¼è¾å ¥å¦ä¸ä»£ç ï¼
Private Sub CommandButton1_Click()注æï¼æ¤å¤å设ç¨æ·å为âå¼ ä¸âï¼å¯ç 为â123456âï¼ä½ å¯ä»¥èªå·±æ´æ¹ãæå·²ç»ä¸ä¼ äºä¸ä¸ªæ ·æ¿ï¼è¯·æ³¨ææ¥ç代ç 并ååºæèã
éé¢æ好å¤æé®ï¼ç¨åªä¸ªæé®
追çå¦æä¸ç¥éç¨åªä¸ªæ§ä»¶çè¯ï¼æé¼ æ æ¬åå¨æ§ä»¶ä¸é¢ä¼æ¾ç¤ºæ§ä»¶çå称ã