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 vote236 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote272 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote245 views1 answer
Reference to a non-shared member requires an object reference
VBA
-1 vote268 views1 answer
Vba sendkeys
VBA
0 vote233 views1 answer
Vba first cell in range
VBA
31 votes538 views1 answer
Vba how to convert a column number into an Excel column
VBA
4 votes241 views2 answers
Excel vba last column with data
VBA
0 vote227 views1 answer
Get current year vb
VBA
0 vote234 views1 answer
Dynamic array vba
VBA
0 vote289 views1 answer
How to call gcd in vba
VBA