Private Function test(ByVal n As Long) As String
Dim s As String
s = "零壹贰叁肆伍陆柒八九"
Dim tmp As String, t As String
tmp = CStr(n)
Dim i As Long
For i = 0 To 9
tmp = Replace(tmp, CStr(i), Mid(s, i + 1, 1))
Next
test = tmp
End Function
Private Sub Command1_Click()
MsgBox test(34901)
End Sub
Private Function cNumToStr(ByVal pStr As Long) As String
Dim strTemp As String * 1, i%, strResult As String, strCmp As String
strCmp = "壹贰叁肆伍陆柒八九"
For i = 1 To Len(CStr(pStr))
strTemp = Mid(CStr(pStr), i, 1)
strResult = strResult & Mid(strCmp, strTemp, 1)
Next
Debug.Print strResult
End Function
'调用
Private Sub Command1_Click()
Dim strRet As String
strRet = cNumToStr(23456)
Debug.Print strRet
End Sub
Private Sub Command1_Click()
Dim strTemp As String * 1, i%, x As String, strResult As String, strCmp As String
x = "1234589"
strCmp = "贰叁肆伍陆柒八九"
For i = 1 To Len(x)
strTemp = Mid(x, i, 1)
strResult = strResult & Mid(strCmp, strTemp, 1)
Next
Debug.Print strResult
End Sub