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 vote158 views4 answers
How to continue formula in below line in vba code
VBA
0 vote160 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote143 views1 answer
Vba test optional argument
VBA
0 vote160 views1 answer
Excel run macro every 5 minutes
VBA
0 vote137 views1 answer
Vbnet add new ecel sheet
VBA
0 vote157 views1 answer
Show unix time in vba
VBA
1 vote164 views1 answer
Vb.net get name by Cell Click
VBA
0 vote169 views1 answer
Vba round to 2 decimals
VBA
0 vote147 views1 answer
How to use VBA to add new record in MS Access?
VBA
1 vote161 views1 answer
Export datagridview to excel vb.net
VBA