Excel VBA Introduction Part 53.1 - Working with Strings
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html
By Andrew Gould
You can download the sample data used in this video here https://www.wiseowl.co.uk/videos/excelvba/working-with-strings.htm
https://www.wiseowl.co.uk - This video explains the basics of working with text, or strings, in VBA. You'll learn about the String data type, how to use the $ type-declaration character and how to create variable and fixed-length strings. You'll see how to concatenate multiple values into a single string, including some string constants for special characters such as tab spaces and new lines - ever wondered why there are so many ways to create a new line in VBA? This video explains why! The final part of the video talks about comparing strings, including how to deal with case-sensitive comparisons and how to use wildcard characters to match paterns of text.
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 Introduction Part 53.1 - Working with Strings канала WiseOwlTutorials
You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html
By Andrew Gould
You can download the sample data used in this video here https://www.wiseowl.co.uk/videos/excelvba/working-with-strings.htm
https://www.wiseowl.co.uk - This video explains the basics of working with text, or strings, in VBA. You'll learn about the String data type, how to use the $ type-declaration character and how to create variable and fixed-length strings. You'll see how to concatenate multiple values into a single string, including some string constants for special characters such as tab spaces and new lines - ever wondered why there are so many ways to create a new line in VBA? This video explains why! The final part of the video talks about comparing strings, including how to deal with case-sensitive comparisons and how to use wildcard characters to match paterns of text.
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 Introduction Part 53.1 - Working with Strings канала WiseOwlTutorials
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Excel VBA Introduction Part 53.2 - Splitting Strings](https://i.ytimg.com/vi/5pXbaVJIqec/default.jpg)
![](https://i.ytimg.com/vi/opoVorHBq4Q/default.jpg)
![How to use Regular Expressions with Excel VBA (Part 1)](https://i.ytimg.com/vi/OS7BPjTy3H0/default.jpg)
![How to make your Excel VBA code run 1000 times faster.](https://i.ytimg.com/vi/GCSF5tq7pZ0/default.jpg)
![](https://i.ytimg.com/vi/UrHFnoqT44E/default.jpg)
![Excel VBA Introduction Part 52.1 - Introduction to Shapes](https://i.ytimg.com/vi/GK7ifXM3alI/default.jpg)
![Excel VBA Beginner Tutorial](https://i.ytimg.com/vi/G05TrN7nt6k/default.jpg)
![How to use ADO and VBA to Read from Worksheets](https://i.ytimg.com/vi/L0I24NGrUtc/default.jpg)
![Introduction to Programming in Visual Basic for Applications (VBA) in Microsoft Access (Access VBA)](https://i.ytimg.com/vi/uvmtcjJeBe4/default.jpg)
![How to Use Left, Right, Mid, Instr, and Trim on Strings in MS Access and VBA](https://i.ytimg.com/vi/nMlauZhskLk/default.jpg)
![Excel VBA Introduction Part 29.8 - Saving Attachments from an Outlook Folder](https://i.ytimg.com/vi/6EGhTg1o2qA/default.jpg)
![Free Excel VBA Course #10 - Working with Workbooks using VBA in Excel (Open, Close, Save)](https://i.ytimg.com/vi/U8IJp1nOD5Y/default.jpg)
![Excel VBA Introduction Part 56.5 - Basic ADO Commands](https://i.ytimg.com/vi/El-tWdO8auw/default.jpg)
![Learn Excel - Increment Invoice # OCT13001 - Podcast 1812](https://i.ytimg.com/vi/kn2LoD2Rh8k/default.jpg)
![EXCEL VBA Fortgeschrittene #4 - Funktion / Function selbst erstellen](https://i.ytimg.com/vi/Cp_8JtZpYPY/default.jpg)
![Free Excel VBA Course #5 - Writing your first VBA Macro Code](https://i.ytimg.com/vi/1SYTGLbAK0Q/default.jpg)
![Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)](https://i.ytimg.com/vi/NpvvwrdDcQk/default.jpg)
![(2/30) Excel VBA Absolute Beginner Course (30 For 30)](https://i.ytimg.com/vi/XChBaEcd_VE/default.jpg)
![How To Create Custom Word Documents From Excel WITHOUT Mail Merge](https://i.ytimg.com/vi/URF3ikW0Svc/default.jpg)
![Learn How To Create This AMAZING File Manager In Excel [Part 1]](https://i.ytimg.com/vi/GHVhfgN7gig/default.jpg)