vba 中split函数及数组搭配for循环的应用

VBA编程：使用split函数处理字符串数组,

最新推荐文章于 2025-07-18 12:57:48 发布

原创最新推荐文章于 2025-07-18 12:57:48 发布 · 1.3k 阅读

8 ·

CC 4.0 BY-SA版权

文章标签：

#开发语言

函数（VBA）专栏收录该内容

47 篇文章

订阅专栏

本文介绍了如何在VBA中使用split函数将多个字符串合并后拆分成数组，并通过for循环逐个访问数组元素。示例代码展示了如何操作字符串变量a、b、c和d。

split函数可以分割字符串，并保存到数组中，通过for循环可以逐个调取数组中的数据，此例通过将多个字符串合并为一个字符串，并用split函数分割成原始字符串存放到数组中，搭配for循环可以逐一取出原始字符串。实例代码如下：

Sub getversion()
Dim a As String, b As String, c As String
Dim d As String
Dim e As String
Dim ee As String
Dim f As String
Dim ff As String
a = "武松"
b = "大郎"
c = "林冲"
d = "李逵"
e = a & "," & b & "," & c & "," & d
f = Split(e, ",")

For i = 1 To 4
    ee = ee & f(i - 1) & ","
Next i
MsgBox ee
ff = Split(ee, ",")
For i = 1 To 4
    MsgBox f(i - 1)
Next i

End Sub