在模組的 宣告 中用 Pablic 關鍵字定義的變數,就是全域性變數.例如:

Function ChuLiStringComma(theString As Variant) As String "處理字串中的逗號(，或,)

"作用: 將指定的字串(theString)進行去逗號操作,使得theString中的"，"變成空格" "

"引數: 1.一個可能包含有逗號的字串.

"返回: 不含逗號的字串

"注意: 無

Dim dimvalue As Variant

If Isnull(theString) Then theString = ""

dimvalue = Split(theString, ",")

If IsArray(dimvalue) Then

ChuLiStringComma = Join(dimvalue, " ")

Else

ChuLiStringComma = theString

End If

End Function