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 vote237 views1 answer
Vba type
VBA
0 vote230 views1 answer
Enable macros on opening workbook vba
VBA
0 vote228 views1 answer
Vbscript abs
VBA
0 vote238 views1 answer
Vba array of integers
VBA
0 vote218 views1 answer
Vb.net round to 2 decimal places
VBA
1 vote248 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote250 views1 answer
Vba sort multiple columns
VBA
0 vote265 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote228 views1 answer
Limit combobox to list vba
VBA
0 vote295 views1 answer
Excel vba paste all to each sheet in workbook
VBA