VBA Str$=“Upper Case”难不成是定义一个变量Str是字符串型的?"Upper “把谁转换成大写?Select Case a$Case "A" To "Z"Str$="Upper Case"Case "a" To "z"Str$="Lower Case"Case "0" To "9"Str$="Number"Case ",",",",".",";"Str$="Punctuato
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/20 05:59:19
![VBA Str$=“Upper Case”难不成是定义一个变量Str是字符串型的?](/uploads/image/z/14115861-45-1.jpg?t=VBA+Str%24%3D%E2%80%9CUpper+Case%E2%80%9D%E9%9A%BE%E4%B8%8D%E6%88%90%E6%98%AF%E5%AE%9A%E4%B9%89%E4%B8%80%E4%B8%AA%E5%8F%98%E9%87%8FStr%E6%98%AF%E5%AD%97%E7%AC%A6%E4%B8%B2%E5%9E%8B%E7%9A%84%3F%22Upper+%E2%80%9C%E6%8A%8A%E8%B0%81%E8%BD%AC%E6%8D%A2%E6%88%90%E5%A4%A7%E5%86%99%3FSelect+Case+a%24Case+%22A%22+To+%22Z%22Str%24%3D%22Upper+Case%22Case+%22a%22+To+%22z%22Str%24%3D%22Lower+Case%22Case+%220%22+To+%229%22Str%24%3D%22Number%22Case+%22%2C%22%2C%22%2C%22%2C%22.%22%2C%22%3B%22Str%24%3D%22Punctuato)
VBA Str$=“Upper Case”难不成是定义一个变量Str是字符串型的?"Upper “把谁转换成大写?Select Case a$Case "A" To "Z"Str$="Upper Case"Case "a" To "z"Str$="Lower Case"Case "0" To "9"Str$="Number"Case ",",",",".",";"Str$="Punctuato
VBA Str$=“Upper Case”难不成是定义一个变量Str是字符串型的?"Upper “把谁转换成大写?
Select Case a$
Case "A" To "Z"
Str$="Upper Case"
Case "a" To "z"
Str$="Lower Case"
Case "0" To "9"
Str$="Number"
Case ",",",",".",";"
Str$="Punctuaton"
Case ""
Str$="Null String"
Case Is
VBA Str$=“Upper Case”难不成是定义一个变量Str是字符串型的?"Upper “把谁转换成大写?Select Case a$Case "A" To "Z"Str$="Upper Case"Case "a" To "z"Str$="Lower Case"Case "0" To "9"Str$="Number"Case ",",",",".",";"Str$="Punctuato
在变量名后面加上美元符号“$”,就是声明这个变量是字符串,跟语句声明"dim Str as string "的作用是一样的.
类似的用法:
$ string
% integer
# double
& long
!single