Excel VBA Introduction Part 9 - Object Variables
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
https://www.wiseowl.co.uk - Object variables in VBA allow you to store references to objects in memory. They're slightly more complex to use than basic data-type variables, but well worth the effort and this video explains why! You'll learn how to declare object variables and how to set references to existing objects. The video also shows you how to return references to objects using the methods of other objects with examples including generating new workbooks and worksheets, as well as using the Find method to reference cells.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Видео Excel VBA Introduction Part 9 - Object Variables канала 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
https://www.wiseowl.co.uk - Object variables in VBA allow you to store references to objects in memory. They're slightly more complex to use than basic data-type variables, but well worth the effort and this video explains why! You'll learn how to declare object variables and how to set references to existing objects. The video also shows you how to return references to objects using the methods of other objects with examples including generating new workbooks and worksheets, as well as using the Find method to reference cells.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Видео Excel VBA Introduction Part 9 - Object Variables канала WiseOwlTutorials
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel VBA Introduction Part 10 - Message BoxesHow VBA Objects Really Work in MemoryIntroduction to Objects, Properties, Methods, and Events in VBAExcel VBA: Practical Guide to Start Using Dictionary [4 Awesome Examples]Excel VBA Les variables Tableaux Part1Excel VBA Introduction Part 25 - ArraysFree Excel VBA Course #12 - Using Object Variables in Excel VBAExcel VBA Introduction Part 8 - VariablesExcel VBA Introduction Part 22 - Files and Folders (FileSystemObjects)How to get the Last Row in VBA(The Right Way!)Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)Excel VBA Introduction Part 1 - Getting Started in the VB EditorExcel VBA Introduction Part 11.1 - Input BoxesClass Modules Explained in Simple English (with examples)Excel VBA Introduction Part 20.1 - Event ProceduresExcel VBA basics: Data types, DIM & SET (Learn to use them correctly)VBA Object Libraries, Early & Late Binding (Серия VBA 34)