If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
Download files here www.wiseowl.co.uk/videos/excelvba/converting-case.htm
www.wiseowl.co.uk - This video explains how to change the case of text using VBA. You'll see how to make string comparisons case insensitive using the Option Compare statement as well as the UCase, LCase and StrComp functions. You'll learn how to convert strings to Proper Case or Title Case. The video also explains how to create custom functions for converting text into Sentence Case and to toggle the case of individual characters in a string.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to becoming a programmer in Excel. You don't need any prior programming knowledge as we'll take things from first principles and hopefully give you a flavour of the cool things you can do with a little bit of effort!