广

Word教程

  • WPS教程
  • Word教程
  • Excel教程
  • PowerPoint教程
  • 首页 > 学习 > 办公软件 > Word

    word用VBA快速输入拼音

    2018-11-09 09:48:54 次阅读 稿源:互联网
    零七广告

    输入时输入对应的元音加声调,然后利用VBA统一替换,这样速度快多了。

    如:she1ng dia4o

    选中后,运行下面的宏就可得到:

    shēng diào

    对于有时要输入小学语文类的拼音尤其有用。可以考虑把这个宏放到对应的模板中。

    VBA代码如下:

    Dim findarr, replacearr

    Dim i As Long

    Application.ScreenUpdating = False

    findarr = Array("a1", "a2", "a3", "a4", _

    "o1", "o2", "o3", "o4", _

    "e1", "e2", "e3", "e4", _

    "i1", "i2", "i3", "i4", _

    "u1", "u2", "u3", "u4", _

    "v1", "v2", "v3", "v4")

    replacearr = Array("ā", "á", "ǎ", "à", _

    "ō", "ó", "ǒ", "ò", _

    "ē", "é", "ě", "è", _

    "ī", "í", "ǐ", "ì", _

    "ū", "ú", "ǔ", "ù", _

    "ǖ", "ǘ", "ǚ", "ǜ")

    For i = 0 To UBound(findarr)

    With Selection.Find

    .Execute findarr(i), MatchWildcards:=False, Format:=False, replacewith:=replacearr(i), Replace:=wdReplaceAll

    End With

    Next

    Application.ScreenUpdating = True

    End Sub

    零七网部分新闻及文章转载自互联网,供读者交流和学习,若有涉及作者版权等问题请及时与我们联系,以便更正、删除或按规定办理。感谢所有提供资讯的网站,欢迎各类媒体与零七网进行文章共享合作。

    零七广告
    零七广告
    非官媒广告
    全网推广平台,软文发布