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

4 votes242 views1 answer
Vba create directory
VBA
0 vote245 views1 answer
Search in richtextbox vb.net
VBA
32 votes335 views2 answers
Excel vba column letter
VBA
1 vote262 views1 answer
Vba ubound array 2-dimensional
VBA
1 vote214 views1 answer
Vba listindex select multiple items vba
VBA
0 vote238 views1 answer
Vba sort multiple columns
VBA
0 vote236 views1 answer
Vba find sub dictionary
VBA
0 vote246 views1 answer
VB Error Code BC30201
VBA
1 vote248 views1 answer
Vba refresh pivot table
VBA
5 votes632 views1 answer
Vlookup vba
VBA