å¯ä»¥ä½¿ç¨VBAè¿è¡æä½ã
å¤å¶å¦ä¸ä»£ç å°æè¦è¿è¡ççsheet代ç ä¸ï¼å¯éå½ä¿®æ¹ã
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)åå¦B10B11å·²ç»æææ¬åå¨ï¼å¦ææ³å®ç°åå»B2ï¼å 容èªå¨è½¬æ¢å°B11çä¸ä¸è¡-B12ï¼éè¦æä¹å
追ç该åå¨B11åè¿æ没ææ°æ®äºï¼å¦æ没æï¼å¯ä»¥ç¨cells(65536ï¼2).end(xlup).row+1å®ä½è¯¥è¡ã
追é®ä½ Qå¤å°ï¼ æç´æ¥ä¸é¢é®ä½ å§
追çPrivate Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)å°±æ¯è¿ä¸ªææï¼å¯æ¯æåç®æ åä¸è½å®ç°äºï¼ç°å¨åå»B2ï¼åªæB2åå æ ¼çå 容转æ¢ä¸å»ï¼C2çå 容å´æ²¡æï¼è¿æï¼ææ³æB2ï¼å°B10设置åæ ·ç模å¼ï¼æä¹ä¸æ¬¡æ§å ¨è®¾ç½®ï¼å¦å¤ï¼å¦æææ³å®ç°ï¼åå»B11.....B19ï¼ææåä¸ï¼åä¼è½¬å°B20...B28ï¼éè¦æä¹å¼ãVBAè¿åæä¸å¤§ç½æ¿ æ±æäº
追çPrivate Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)ä¸å¯¹ï¼è¯·ä½ ç好ååä¸æ¥ï¼è¿åç两个é½æ¯éçï¼ä¸ä¸ªè¿½é®åæåºäºè¦æ±ï¼å¸®æä¸åå¼å¥½å§ï¼è°¢äº
追çPrivate Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)