Excel閷勫叆涓鐝惧柈鍏冩牸澶氶伕闋呰嚜鍕曚笅鎷�


銆愭憳瑕併€戠挵(hu谩n)鐞冪恫鏍℃暣鐞嗙殑“Excel閷勫叆涓鐝惧柈鍏冩牸澶氶伕闋呰嚜鍕曚笅鎷�”锛岄嚌灏嶅湪Excel浣跨敤涓鐝惧柈鍏冩牸澶氶伕闋呰嚜鍕曚笅鎷夌殑铏曠悊锛屽笇鏈涘皪澶у瀛哥繏璨″嫏杌熶欢-Excel锛岀敤鍏堕€茶鍋氳超鏈夋墍骞姪锛岀恫鏍¢倓鏈冪辜绾�(x霉)鏇存柊鏇村璨″嫏杌熶欢鐨勬噳鐢ㄦ妧宸х瓑鐩搁棞璩囨枡锛屼緵澶у瀛哥繏鏈冭▓鐭ヨ瓨锛屾暚璜嬮棞娉ㄧ挵(hu谩n)鐞冩渻瑷堝瑷撻牷閬�!
銆€鐩搁棞鎺ㄨ枽锛�濡備綍鍠崹鎵撳嵃Excel鎸囧畾鍗€(q奴)鍩�
銆€銆€鎴戝€戝湪Excel琛ㄦ牸涓渶瑕佽几鍏ュぇ閲忕殑閲嶅京鏁告摎鏅�锛屽線寰€鍒╃敤鏁告摎鐨勬湁鏁堟€т締鍒朵綔涓€鍊嬩笅鎷夎彍鍠互鎻愰珮閲嶅京鏁告摎鐨勮几鍏ラ€熷害銆備絾鍦ㄥ闅涚殑鎿嶄綔閬庣▼涓�锛屽繀闋堥伕涓渶瑕佽几鍏ラ噸寰╂暩鎿氱殑鍠厓鏍煎苟鍠搳瑭插柈鍏冩牸鍙抽倞鐨勪笅鎷夌闋�锛屾墠鍙互鐪嬪埌鑷繁浜嬪厛瀹氬埗鐨勬暩鎿氭湁鏁堟€х殑涓嬫媺鑿滃柈銆傞偅涔�锛岃兘鍚﹀鐝惧湪閬镐腑Excel鍠厓鏍兼檪鑷嫊灞曢枊鏁告摎鏈夋晥鎬х殑涓嬫媺鑿滃柈浠ヤ娇寰楅噸寰╂暩鎿氱殑杓稿叆鏇村揩涓€姝ュ憿?瑭虫儏濡備笅锛�
銆€銆€鍏堝暉鍕旹xcel 2003骞舵墦闁嬫煇鍊嬪凡瑷疆濂芥暩鎿氭湁鏁堟€т笅鎷夎彍鍠殑宸ヤ綔绨�(濡�“宸ヨ硣琛�.xls”)锛岀劧鍚庡柈鎿婅彍鍠�“宸ュ叿→瀹�→Visual Basic 绶ㄨ集鍣�”鍛戒护锛岃鍑�“Visual Basic 绶ㄨ集鍣�”;鎺ヨ憲鍦�“Visual Basic 绶ㄨ集鍣�”绐楀彛涓�锛岄洐鎿�“宸ョ▼ - VBAPRoject”闈㈡澘涓殑“Sheet1(*)”閬搁爡(*鐐虹暥鍓嶉渶瑕佸揩閫熻几鍏ラ噸寰╂暩鎿氱殑宸ヤ綔琛�)锛屽湪褰堝嚭鐨勪唬纰肩獥鍙d腑杓稿叆浠ヤ笅浠g⒓锛�
銆€銆€Option Explicit
銆€銆€Private Sub Worksheet_SelectionChange(ByVal Target As Range)
銆€銆€If Target.Column = 3 Then application.SendKeys “%{down}”
銆€銆€If Target.Column = 4 Then Application.SendKeys “%{down}”
銆€銆€End Sub
銆€銆€涓婅堪浠g⒓杓稿叆瀹岀暍鍚�锛岄棞闁�“Visual Basic 绶ㄨ集鍣�”绐楀彛锛屾鏅傛垜鍊戣几鍏ョ殑浠g⒓灏辨渻鑷嫊淇濆瓨銆�
銆€銆€灏忔彁绀猴細浠g⒓鐨勫惈缇╂槸鐣舵垜鍊戦伕涓3鍒�銆佺4鍒�(鍗矯鍒楀拰D鍒�)鐨勪换鎰忎竴鍊嬪柈鍏冩牸鏅傦紝閮芥渻鑷嫊灞曢枊鏁告摎鏈夋晥鎬х殑涓嬫媺鑿滃柈銆傚湪瀵﹂殯鐨勬搷浣滈亷绋嬩腑锛屽ぇ瀹跺彲闈堟椿鍦颁慨鏀归€欏叐鍊嬭嚜鐒舵暩浠ユ豢瓒宠嚜宸辩殑闇€瑕併€�
銆€銆€瀹屾垚涓婅堪鎿嶄綔鍚�锛岄棞闁�“宸ヨ硣琛�.xls”骞朵繚瀛樺皪鍏舵墍鍋氱殑淇敼锛岀劧鍚庨噸鏂版墦闁嬪畠锛屾帴钁楅伕涓瑿鍒楁垨D鍒楃殑浠绘剰涓€鍊嬪柈鍏冩牸锛屾鏅傚氨鍙互鐪嬪埌瑭插垪鍠厓鏍艰嚜鍕曞睍闁嬬殑鏁告摎鏈夋晥鎬х殑涓嬫媺鑿滃柈浜�銆傞€欐ǎ涓€渚嗘垜鍊戣几鍏ラ偅浜涢噸寰╃殑鏁告摎灏卞彲浠ユ瘮鍘熶締鏇村揩涓€姝ヤ簡銆傛湁姝ら渶姹傜殑鏈嬪弸涓嶅Θ涓€瑭�銆�
銆€銆€鐠�(hu谩n)鐞冪恫鏍″弸鎯呮彁绀猴細濡傛灉鎮ㄥ湪瀛哥繏閬庣▼涓亣鍒颁换浣曠枒鍟� 锛岃珛鐧婚寗鐠�(hu谩n)鐞冪恫鏍℃渻瑷堝韪愭搷浣滆珫澹�锛岄毃鏅傝垏寤eぇ鑰冪敓鏈嬪弸鍊戜竴璧蜂氦娴�!
銆€銆€鏈冭▓蹇呭倷鐭ヨ瓨 | 鏈冭▓鎻愬崌 | 璨″嫏杌熶欢閬嬬敤鎶€宸�
鏈€鏂拌硣瑷�
- 2022骞�9鏈堟禉姹熻病绋呮渻瑷堝斧浠€涔堟檪鍊欐煡鎴愮妇2022-09-20
- 2022骞寸涓夊搴︿腑绱氳病绋呮渻瑷堝斧鐪熼鍙婄瓟妗堣┏瑙o細澶氶伕閮ㄥ垎2022-09-20
- 2022骞�9鏈�18鏃ヤ腑绱氳病绋呭斧鐪熼鍙婄瓟妗堣┏瑙�2022-09-20
- 2022骞寸涓夊涓礆璨$▍甯湡椤屽強绛旀瑙f瀽(鑰冪敓鍥炴喍)2022-09-20
- 2022骞�9鏈�18鏃ヤ腑绱氳病绋呭斧鐪熼绛旀鍙婅В鏋愶細澶氶伕椤�2022-09-19
- 2022骞寸涓夊搴︿腑绱氳病绋呭斧鐪熼绛旀瑙f瀽锛堝閬搁儴鍒嗭級2022-09-19
- 2022骞寸涓夊涓礆璨$▍甯湡椤屽強绛旀2022-09-19
- 2022骞�9鏈堜腑绱氳病绋呮渻瑷堝斧鐪熼闆诲瓙鐗�2022-09-19
- 2022骞�9鏈�18鏃ヤ腑绱氳病绋呮渻瑷堝斧鐪熼鍙婄瓟妗堬紙閮ㄥ垎锛�2022-09-19
- 2022骞村垵绱氳病绋呭斧鐪熼闆诲瓙鐗堬紙9鏈�11鏃ワ級2022-09-15