|
本帖最后由 huchuanxing 于 2016-12-2 12:25 编辑
以下是本人写的数字转换为文本的VBA代码,请帮忙看看代码错在何处:
Sub 数字转文本字()
Dim rng As Range, address As String
If TypeName(Selection) = "Range" Then address = Selection.address Else address = ""
'弹出一个对话框, 让用户选择区域, 默认显示变量address的值。然后将该用户选择区域赋予变量rng
Set rng = Application.InputBox("请选择待转换的区域", "转换区域", address, , , , , 8)
If rng Is Nothing Then Exit Sub
For Each rng In Selection
If rng.Value <> "" Then
rng = CStr(rng.Value)
End If
Next
End Sub
- Sub 数字转文本字()
- Dim rng As Range
- Set rng = Application.InputBox("请选择待转换的区域", "转换区域", Address, , , , , 8)
- If rng Is Nothing Then Exit Sub
- For Each rng1 In rng
- rng1.Value = "'" & rng1.Value
- Next
- End Sub
复制代码
|
|