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 vote129 views4 answers
Jwt token vb.net validation
VBA
5 votes142 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote116 views1 answer
Excel vba disable screen update
VBA
0 vote123 views1 answer
Compare dates vb
VBA
1 vote129 views1 answer
Vbscript convert ascii code to character
VBA
0 vote120 views1 answer
Type excel.application is not defined vb
VBA
-1 vote133 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote127 views1 answer
Vba parameter adodb null value
VBA
0 vote124 views1 answer
Vba get workbook name
VBA
0 vote126 views1 answer
Excel vba copy entire sheet paste values
VBA