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 vote294 views1 answer
Find if year is leap year vb
VBA
5 votes329 views1 answer
Excel vba get user selected range
VBA
0 vote286 views1 answer
Vba copy file
VBA
0 vote291 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote285 views1 answer
Convert unix to date vba
VBA
0 vote291 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote279 views1 answer
Vba sheet visible
VBA
0 vote288 views1 answer
Freeze panes vba
VBA
0 vote283 views1 answer
Convert number to minutes in vba
VBA
0 vote282 views1 answer
Search in richtextbox vb.net
VBA