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 vote442 views1 answer
Excel vba delete columns in range
VBA
22 votes509 views1 answer
Xlvba check for folder
VBA
0 vote343 views1 answer
Vba verticalalignment
VBA
0 vote374 views1 answer
Vba add shape oval
VBA
0 vote393 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote336 views1 answer
Vba format currency
VBA
0 vote370 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote360 views2 answers
How to concatenate more than 40 lines in vba
VBA
3 votes379 views2 answers
Vba date to string
VBA
8 votes406 views1 answer
Vba make integer
VBA