Excel vba to lower case

' To lower, upper and proper case
Dim sText As String
sText = "Run, forrest run"
MsgBox StrConv(sText, vbProperCase)   ' Run, Forrest Run
MsgBox StrConv(sText, vbLowerCase)    ' run, forrest run
MsgBox StrConv(sText, vbUpperCase)    ' RUN, FORREST RUN

Similar codes

0 vote222 views1 answer
Excel R1C1 mode
VBA
0 vote223 views1 answer
Vbs send keys
VBA
8 votes272 views1 answer
Vba make a short integer from two bytes
VBA
0 vote241 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote217 views1 answer
Vba paste values
VBA
0 vote241 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote232 views1 answer
Nested if else in vb.net
VBA
0 vote213 views1 answer
Remove frist letter from string vbnet
VBA
0 vote231 views1 answer
Excel named range sum
VBA
5 votes238 views1 answer
Excel vba second byte from INTEGER
VBA