资源预览内容
第1页 / 共15页
第2页 / 共15页
第3页 / 共15页
第4页 / 共15页
第5页 / 共15页
第6页 / 共15页
第7页 / 共15页
第8页 / 共15页
第9页 / 共15页
第10页 / 共15页
亲,该文档总共15页,到这儿已超出免费预览范围,如果喜欢就下载吧!
资源描述
Excel自定义函数措施: 1启动xcel (其他版本请仿照操作),打开相应的工作表;2.执行“工具宏isua asic编辑器”命令(或者直接按“Alt11”组合键),进入Visal Bi编辑状态; 3.执行“插入模块”命令,插入一种新模块。再双击插入的模块,进入模块代码编辑状态;.将代码输入其中;.代码输入完毕后,关闭isua asic编辑窗口,返回xcel编辑状态;6自定义函数就可以用了,如:选中D2单元格,输入公式:gety(2)。Function pn(p As Sing)s Sringi = Asc()Selt ase ise -01o 18: inyi Cae -2037 To-2030:pinyin =a Case -304 To -2029: pni an Cs -20295 To -20293: pini= angas -20292To 284:pinyin = a Case-2283T -22: pnyn = baCase-20265 o -228: pinyin =ai Case -2057 T -20243: pinyn= ban Cae24To 023: pinyin = ang Case2230To -2:pinyi =ao Cae-1To -7: pnyn = bei ae - To -3: inyin = benCase -2 -7:pinyin = bengCase - T3: piyi bi Case - o -19991: pinyn ia Ca -19990 o -987: pnyin = bia Ca 196To -9983:piyi ie Case -19982 To -1997: pinibin as -996 To -1980: nyi bing Cse 105 o -19785: ini bo ae -9784T976: piyin = Cae 19775 To -9775: pin c Ce -1774 To-1764: inyi = ca Cse 19763 To -1757: pinyin cn ae 9756 To -972:in cang Case -19751 o19747: pinyn= a ase -1976T-1974: pinyi = e Cae -974 To -740: pinyin =ceng Ca 1939To 19729: pinn ch Ce -1928 -172: pnyin = chai ae -1925o -1976: iyin = chCase -1975 To-1951: pnyn =chang Cse -5 o -952:piny =chao Cse -1951 To-126: pny = he Cas-19525To -19516: piyi hen Case -1515To -19501: piny = cng Case-195 To 45:pinyin = ch ase 19484 T -1948:pinyi= chong Case 1479 To -6: nyin cho ase 947 To-19290: inyn = chu Cas -19289 To-989: pnyn= chuai Cae 19288To -9282:pyin an Ca191 To -9276: pnyin = chuang ae -17 To-9271: nin= chui Case 1920 To 194: inyin = chn Case-23 To-19262: pinyi = chuo Cas 161 To19250: pinyin = ciCase 14 To -1924:pnin= c Case 1924 -19243: inyi = couCa 19242 To -1929: pinin = cu s-13To -1923: pnyin = cun Case -19235o 122: piin = uiCas 927 -19225: piyin cunse -1924 To -1919: pi cuo Case -1921 o1923: pinyn = da Cas 121 To-90: pnyin ai a -1903 To -94: inin= dan as -23 T-119:pinyin =dng ae-101 To-190: nyin = dao Case -19006 To -190: piyin =de Cas-1900o -1899: pyn dnCase -189To 189:iin di Cae -18977 To-1862: pinyin ian ae-86 To-895: pinyin =dio Ca -952 T-1784: pinyin = deCas-18783 To -18775: pnyin = dig Case -8774 T -18774: pinyin= diu Cae 8773To -857: inyn = dongas 6 To-1859: nyn= f ase-1518 To 8502: pinyi= fa Cs -1501 To -1891:piin = fang Case -0 o -1479: nyn i Case 1848 To -18464:piny =fen Cae -1843To -1849: pinyn feg ase 448To -18448: inyi=fo Cs 8447To -1847: pini = fou as -1446 To-820: pnyin = u Ce -8239 To 18238:pii =ga Ca -18237 To -183: inyin = gaCe -1231To -82: pinyin = an Case -182o -82: pinyin = gag Cse-211To -8202:inyin o as -12 To -181: piy= ge ase -1884 T -1884: pinyin gei Cse 813T-1882:inn = g Case -1881 To -180: inin = gen Case -18012 To -79: piin = gong Case-17997 To -799: pinyin = ou Cas178To7971: pinyn = guase -790T17965: pinyin= guaCse 1794 o 76: pin = ua Ce 17961To-1791: nyin =guanCase -1790 To-1794: inyin uang Case -17 -17932: piyin = gui Case-1731To 17929: inin gun Case -1728To -1793:pnyin =go ase 792 To -1760: pinyi = ha Cae-175 To 17753:iin = hi Cae -7752 To -17734: pinyin =hnCase -7733 To -17731:pinyihang Ce -17730 T -17722:pny =haoCas -17721 T-704: pinyin= he Case -703 o -1702: pnyin = hei Cse -1771 o -1769: inyn= hn ase -17697 o -1763:i=hngas -17692 To18: pinyin =hn Cae 17683T 1677: pi= hou Cae-776 To -97: pny = h se -46T-1748: pnyin =hua Cae -748 To 17483: pyin = uai Cae -142 To 146: pyn = hun Case -17468To-5: pini= uag Cse -1454To -1744: piy= hiCse-173T 1748: piyin hun Cae-17427 To -171: inin = huo Cse 17417 To -17203: piyin = jiCse -120 To 1716:piy =jia
网站客服QQ:2055934822
金锄头文库版权所有
经营许可证:蜀ICP备13022795号 | 川公网安备 51140202000112号