ä½ æ说çæ
åµåªè½ä½¿ç¨å®ãæ alt + F11 å¯å¨VBA, å¨å·¦è¾¹çå°çªå£ï¼æ¾ç¤ºæä½ éè¦è¾å
¥æ°æ®çå·¥ä½è¡¨å称ï¼åå»è¿ä¸ªå·¥ä½è¡¨å称ï¼ç¶åå¨å³è¾¹ç空大çªå£è¾å
¥å¦ä¸ä»£ç å°±å¯ä»¥äºï¼Public Sub Worksheet_Change(ByVal Target As Range)On Error Resume Next'éå°é误继ç»è¿è¡ä»£ç If Target.Column = 1 And Target.Text <> "" Then'ç¨ifå½æ°ï¼å¦ææ´»å¨åå
æ ¼ä¸ºAå(1å°±æ¯Aåï¼è¿éä½ å¯ä»¥æ´æ¹ä¸ºä»»æåï¼æ¯å¦2=Båï¼3=Cåï¼4=Dåçç)ä¸åå
æ ¼å
容为空ï¼åæ§è¡ä¸åå¨ä½ Target.Offset(0, 1) = Now Selection.NumberFormatLocal = "yyyy-m-d h:mm;@"'æ´»å¨åå
æ ¼çåä¸åèªå¨å¡«å
æ¶é´ï¼æ ¼å¼ä¸º"yyyy-m-d h:mm;@"End If'å®æå¤æEnd Sub'代ç æ§è¡å®æ¯
温馨提示:答案为网友推荐,仅供参考