excel中alt+asc码的对照表~~~ 循环显示26个小写字母的ascⅡ码。每行十个。按alt+f1...
excel\u91cc\u9762\u201calt+enter\u201d\u600e\u4e48\u641c\u7d22alt+enter\u7ec4\u5408\u952e\u662fexcel\u5f3a\u5236\u6362\u884c\u952e\u3002\u5728excel\u91cc\u53ef\u4ee5\u7528\u67e5\u627e\u7684\u65b9\u5f0f\u67e5\u627e\u6362\u884c\u7b26\u3002
\u6309\u4e0b\u5feb\u6377\u952ectrl+f\uff0c\u6216\u8005\u70b9\u51fb\u67e5\u627e\u547d\u4ee4\uff0c\u5728\u67e5\u627e\u5185\u5bb9\u4e2d\uff0c\u6309\u4e0balt\u952e\uff0c\u5728\u5c0f\u952e\u76d8\u533a\u8f93\u516510\uff0c\u70b9\u51fb\u67e5\u627e\u5168\u90e8\uff0c\u5de5\u4f5c\u8868\u4e2d\u5b58\u5728\u7684\u6362\u884c\u7b26\u5c31\u5168\u90e8\u88ab\u627e\u5230\u3002
\u8bd5\u8bd5\u770b\uff1a
DATAS SEGMENT
XX DB 'a'
YY DB 0
DATAS ENDS
CODES SEGMENT
ASSUME CS:CODES, DS:DATAS
START:
MOV AX, DATAS
MOV DS, AX
LOP2:
MOV AL, XX
CALL OUT_HEX
;===============\u5728\u8fd9\u91cc\u5224\u65ad\u6709\u6ca1\u6709\u6309\u4e0balt+f1
MOV AH, 1 ;\u5224\u65ad\u6709\u65e0\u952e\u8f93\u5165
INT 16H
JZ NEXT ;\u65e0
MOV AH, 0 ;\u6709, \u8bfb\u952e
INT 16H
CMP AX, 6800H
JE EXIT
;==============\u6309\u4e0balt+f1\u7ed3\u675f\u7a0b\u5e8f
NEXT:
INC XX
CMP XX, 'z' + 1
JB LOP1
MOV XX, 'a'
LOP1:
INC YY
CMP YY, 10
JNZ LOP2
MOV YY, 0
CALL CR_LF
JMP LOP2
;-------------------------
EXIT:
MOV AH, 4CH
INT 21H
;=====================================
CR_LF:
MOV AH, 2
MOV DL, 13
INT 21H
MOV DL, 10
INT 21H
RET
;=====================================
OUT_HEX:
MOV AH, 0
MOV BL, 16
DIV BL
PUSH AX
MOV DL, AL
MOV AH, 2
ADD DL, '0'
CMP DL, 3AH
JB OUT1
ADD DL, 07H
OUT1:
INT 21H
;-----
POP AX
MOV DL, AH
MOV AH, 2
ADD DL, '0'
CMP DL, 3AH
JB OUT2
ADD DL, 07H
OUT2:
INT 21H
MOV DL, 'H'
INT 21H
MOV DL, ' '
INT 21H
RET
;=====================================
CODES ENDS
END START
\u8fd0\u884c\u540e\uff0c\u4e0d\u505c\u7684\u6eda\u52a8\u8f93\u51fa\uff1a
61H 62H 63H 64H 65H 66H 67H 68H 69H 6AH
6BH 6CH 6DH 6EH 6FH 70H 71H 72H
c:\masm510>
\u6309\u4e0balt+f1\uff0c\u624d\u80fd\u7ed3\u675f\u3002
收藏了，好东西~
绛旓細alt + 39 鏂囨湰 alt + 40 (alt + 41 )alt + 42 alt + 43 + alt + 44 ,alt + 45 - alt + 46 .alt + 47 鏂囦欢 alt + 48 0 alt + 49 1 alt + 50 2 alt + 51 3 alt + 52 4 alt + 53 5 alt + 54 6 alt + 55 7 alt + 56 8 alt + 57 9 alt + 58 :alt +...
绛旓細01銆侀鍏堬紝鎴戜滑鎵撳紑鎴戜滑鐢佃剳涓婇潰鐨excel锛屼箣鍚庢垜浠换鎰忕偣鍑婚変腑涓涓崟鍏冩牸锛02銆佺劧鍚庢垜浠偣鍑诲伐鍏锋爮涓殑鎻掑叆锛03銆佷箣鍚庢垜浠偣鍑荤鍙凤紱04銆佸脊鍑虹殑鐣岄潰锛屾垜浠偣鍑诲瓙闆嗚竟涓婄殑涓嬫媺绠ご锛屽脊鍑虹殑鐣岄潰锛屾垜浠偣鍑绘暟瀛﹀舰寮忥紱05銆佷箣鍚庢垜浠偣鍑婚挬锛岀劧鍚庢垜浠偣鍑绘彃鍏ワ紱06銆佺粨鏋滃鍥炬墍绀猴紝杩欐牱鎴戜滑灏卞湪琛ㄦ牸涓墦閽╀簡銆
绛旓細1.灏咥鍒楁暟鎹浆鎹㈡垚鎷奸煶锛2.alt+F11鎻掑叆妯″潡锛屽湪妯″潡涓緭鍏ュ涓嬩唬鐮侊紝浠ｇ爜寰堝锛堢敱浜庣瘒骞呴檺鍒讹紝鏃犳硶灏嗗叏閮ㄤ唬鐮佸彂涓婃潵锛屽彲浠ユ悳绱㈡眽瀛ASC鐮鏉ヨ幏鍙栵級锛屼絾鍘熺悊寰堢畝鍗曪紝鍒╃敤姣忎釜姹夊瓧鐨凙SC鐮佹潵寰楀埌杩欎釜姹夊瓧鐨勬嫾闊筹紝鐒跺悗渚濇鎻愬彇鍗曞厓鏍涓殑姣忎竴涓眽瀛楋紝鍒嗗埆鑾峰緱鍏舵嫾闊炽侳unction pinyin(p As String) As String i...
绛旓細閫変腑閭ｄ竴鍒楋紝鐒跺悗杩涘叆"鏁版嵁鈥濊彍鍗曗斺斿垎鍒椻斺斿垎闅旂鍙封斺旀牴鎹暟鎹腑鏄剧ず鐨勫垎闅斿紑鐨勭鍙疯缃斺斾笅涓姝ワ紝瀹屾垚銆備綘鍙互灏濊瘯涓涓嬶紝鐪嬬湅鏄惁鑳借揪鍒颁綘鎯宠鐨勭粨鏋溿
绛旓細Excel涓鍙互鍒╃敤鑷畾涔夊嚱鏁版潵瀹炵幇灏嗘眽瀛楄浆鎹㈡垚鎷奸煶銆傛墍鐢ㄥ伐鍏凤細Office2007 涓句緥璇存槑濡備笅锛1.灏咥鍒楁暟鎹浆鎹㈡垚鎷奸煶锛2.alt+F11鎻掑叆妯″潡锛屽湪妯″潡涓緭鍏ュ涓嬩唬鐮侊紝浠ｇ爜寰堝锛堢敱浜庣瘒骞呴檺鍒讹紝鏃犳硶灏嗗叏閮ㄤ唬鐮佸彂涓婃潵锛屽彲浠ユ悳绱㈡眽瀛ASC鐮鏉ヨ幏鍙栵級锛屼絾鍘熺悊寰堢畝鍗曪紝鍒╃敤姣忎釜姹夊瓧鐨凙SC鐮佹潵寰楀埌杩欎釜姹夊瓧鐨勬嫾闊筹紝鐒跺悗渚濇...
绛旓細绗竴涓棶棰,妤间笂宸茬粡瑙ｇ瓟浜,a=-20318 b=chr(a)鍗冲彲寰楀埌闃 绗簩涓棶棰:棣栧厛VBA涓笉鏀寔Chrw(1606)杩欎釜闃挎媺浼瓧姣,VBA濮嬬粓灏嗗叾鏄剧ず涓"?"鑰ASC("?")鏄竴鐩寸瓑浜63鐨.鎵浠ュ彧瑕佹槸VBA涓嶈璇嗙殑瀛楃閮藉皢浠?浠ｆ浛
绛旓細鍏蜂綋姝ラ:鎵撳紑涓涓excel琛,姣斿浣犺鐨勬暟鎹湪sheet1鐨勪竴琛屽凡鍒椾腑 鎸alt+F11杩涘叆缂栬緫妯″紡,鍦ㄥ乏渚х偣鍙抽敭,鎻掑叆--妯″潡 鎶婂涓嬩唬鐮佺矘璐磋繘鍘 :sub finddaxie()len1=len(sheets("sheet1").cells(1,1).value)for i=1 to len1 t=asc(mid(sheets("sheet1").cells(1,1).value,i,1))if t>=65 ...
绛旓細Excel涓璦sc鍑芥暟鐢ㄦ硶寰堢畝鍗曪紝浣嗛潪甯稿疄鐢ㄣ傜涓锛宎sc鍑芥暟鐢ㄦ硶璇存槑 asc鍑芥暟鐨勪綔鐢ㄥ氨鏄皢鍏ㄨ锛堝弻瀛楄妭锛夊瓧绗︽洿鏀逛负鍗婅锛堝崟瀛楄妭锛夊瓧绗︺俛sc鍑芥暟鐨勮娉曚负锛ASC(text)鍏朵腑鐨勫弬鏁帮細Text鏄繀闇鐨勫弬鏁般傚彲浠ユ槸鏂囨湰鎴栬呮槸瀵瑰崟鍏冩牸鐨勫紩鐢ㄣ傛敞鎰忥細濡傛灉鏂囨湰涓笉鍖呭惈浠讳綍鍏ㄨ瀛楁瘝锛屽垯鏂囨湰涓嶄細鏇存敼銆傜浜岋紝asc鍑芥暟绠鍗曚妇渚...
绛旓細ASC鍑芥暟鐨勭敤娉 棣栧厛锛屾垜浠厛鏂板缓涓涓Excel琛ㄦ牸銆 鏂板缓瀹屾垚鍚庢垜浠睘浜庝袱涓叏瑙掑瓧绗︿緥瀛愩 榧犳爣鍗曞嚮B2鍗曞厓鏍硷紝鍦ㄨ緭鍏ユ爮涓緭鍏モ=ASC锛圓2锛夆濄 杈撳叆瀹屾垚鍚庯紝鎸夊洖杞﹂敭锛屼究鍙緱鍒拌浆鎹㈠畬鎴愮殑鍗婅瀛楃銆 榧犳爣鍗曞嚮B3鍗曞厓鏍硷紝鍦ㄨ緭鍏ユ爮涓緭鍏モ=ASC锛圓3锛夆濄 杈撳叆瀹屾垚鍚庯紝鎸...
绛旓細鎴栬匔trl+H璋冨嚭 绗簩姝ワ細鎵撳紑閿洏涓婄殑numlock閿紙閮ㄥ垎绗旇鏈數鑴戦渶瑕佺偣鍑籪n閿+鏍囧織鏈夆渘umlock鈥濆瓧鏍风殑閿級锛岀洰鐨勬槸鎵撳紑鏁板瓧灏忛敭鐩 绗笁姝ワ細鍦ㄦ煡鎵炬爮鎸変綇alt閿殑鍚屾椂杈撳叆10锛屾敞鎰忎竴瀹氳鍦ㄦ暟瀛楀皬閿洏涓婇敭鍏10锛屾鏃舵病鏈変换浣曟樉绀猴紝浣嗘槸宸茬粡杈撳叆浜嗘崲琛岀鐨ASC鐮銆傛浛鎹㈡爮涓嶇敤绠°傜偣鍑荤‘瀹 鏈缁堟晥鏋滐細...
