Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel

Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel

Home › Other Content › Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel
Sources from Get eSolutions, • Youtube on Youtube • Published 7 years ago
ChannelPublish DateThumbnail & View CountActions
Channel Avatar Get eSolutions2017-10-29 05:44:24 Thumbnail
130,941 Views
View on YouTube View Channel
How to enable Change case (Lowercase, Uppercase, Proper case letters) in MS-Excel 2007, 2010, 2013 & 2016 Without Formula using Macro code (VBA-Visual Basic Editor)

————————–Macro Code———————–

Sub ChangeTextCase()

Dim strChange As String

strChange = InputBox(/”Type l, u, or p to change case:/” & vbCr & vbLf & vbCr & vbLf & _
/”Lowercase = l, uppercase = u, proper case = p/

Please take the opportunity to connect and share this video with your friends and family if you find it useful.