Function ch(x As Range) As String
Dim A()
Dim i As Integer
A = Array("K", "B", "C", "D", "E", "F", "G", "H", "I", "J")
For i = 1 To Len(x)
ch = ch & A(Mid(x, i, 1))
Next i
End Function
Sub test()
Dim num, str$, i%, n%
num = InputBox("数字:", "输入", 5431)
If num = "" Then End
For i = 1 To Len(num)
n = Mid(num, i, 1)
If VBA.IsNumeric(n) Then
str = str & Chr(65 + n)
Else
str = "这不是一个数字"
End If
Next i
MsgBox str, , "结束"
End Sub
Function ch(x As Range) As String
Dim A()
Dim i As Integer
A = Array("K", "B", "C", "D", "E", "F", "G", "H", "I", "J")
For i = 1 To Len(x)
ch = ch & A(Mid(x, i, 1))
Next i
End Function