1、首先打开电脑中的Excel软件，找打新建，点击新建后，创建一个新的空白文档。
2、然后在表格中输入姓名和拼音，制作成一个如图的表格，制作完成后在键盘上同时按住Alt+F11进入VB窗口。
3、接下来点击插入后找到模块，在模块中输入Opt坡纠课柩ion Explicit Function PY(TT As Stri荏鱿胫协ng) As Variant Dim i%, temp$ PY = "" For i = 1 To Len(TT) temp = Asc(Mid$(TT, i, 1)) If temp > 255 Or temp < 0 Then PY = PY & pinyin(Mid$(TT, i, 1)) Else PY = PY & LCase(Mid$(TT, i, 1)) End If Next i End Function Function pinyin(myStr As String) As Variant On Error Resume Next myStr = StrConv(myStr, vbNarrow) If Asc(myStr) > 0 Or Err.Number = 1004 Then pinyin = "" pinyin = Application.WorksheetFunction.VLookup(myStr, [{"吖","A";"八","B";"嚓","C";"搭","D";"蛾","E";"发","F";"噶","G";"铪","H";"击","J";"咔","K";"垃","L";"妈","M";"拿","N";"噢","O";"啪","P";"七","Q";"然","R";"仨","S";"他","T";"挖","W";"夕","X";"压","Y";"座","Z"}], 2) End Function
4、最后退出界面关闭VB窗口，在表格中找到要标称拼音的地方输入=PY(A2）后，点击键盘回车键。
