filmov
tv
VBA Put text in upper case

Показать описание
Transform any text to an upper cased text.
Code:
Sub text_upper_case()
Dim myText As String
Dim myText_uppercase As String
'set text
myText = "An example"
'transform text
myText_uppercase = UCase(myText)
'message
MsgBox ("My text was: " & myText & ", and became this: " & myText_uppercase)
End Sub
-------------------------------
NEED HELP?
-------------------------------
Leave a comment with your questions, issues or projetcs and I will try to answer with a video.
-------------------------------
THANK YOU
-------------------------------
For watching my videos,
Your shares
And your comments!
Code:
Sub text_upper_case()
Dim myText As String
Dim myText_uppercase As String
'set text
myText = "An example"
'transform text
myText_uppercase = UCase(myText)
'message
MsgBox ("My text was: " & myText & ", and became this: " & myText_uppercase)
End Sub
-------------------------------
NEED HELP?
-------------------------------
Leave a comment with your questions, issues or projetcs and I will try to answer with a video.
-------------------------------
THANK YOU
-------------------------------
For watching my videos,
Your shares
And your comments!