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

5 votes223 views1 answer
Excel vba low word from Long Integer
VBA
3 votes235 views1 answer
Extract word in a text in excel
VBA
0 vote216 views1 answer
Vbnet click on dgv cells
VBA
0 vote227 views1 answer
Delete all controls in an area vb
VBA
0 vote201 views1 answer
Excel vba clear filter
VBA
0 vote197 views1 answer
Excel vba disable copy paste
VBA
0 vote219 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote235 views1 answer
Excel vba protect sheet
VBA
0 vote208 views1 answer
Vba sort the data Z to A
VBA
0 vote194 views1 answer
Do until vb.net
VBA