Excel VBA Introduction Part 52.1 - Introduction to Shapes

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

You can download the file created in this video from this page https://www.wiseowl.co.uk/videos/excelvba/intro-to-shapes.htm

By Andrew Gould

https://www.wiseowl.co.uk - In this video you'll learn the basic of working with shapes in VBA. You'll see how to reference objects in the shapes collection using a variety of techniques. You'll learn about the properties which determine a shape's size and position and how to set these relative to other objects. You'll also learn how to add a variety of shapes to a worksheet, including basic autoshapes, pictures and form control buttons, as well as how to attach an action to a shape so that it runs a macro when a user clicks it.

Chapters
00:00 Topics
00:52 Examples of Shapes
03:18 Referring to the Shapes Collection
05:26 Referring to a Single Shape
07:10 Referring to a Range of Shapes
08:09 Referring to a Range of Shapes by Name
08:53 Referring to Selected Shapes
10:42 Using a Variable to Reference a Shape
11:59 Looping Over the Shapes Collection
13:41 Using a For Next Loop
15:23 Shape Size and Position
17:05 Changing a Shape's Size and Position
18:38 Positioning Relative to Other Shapes
19:26 Positioning Relative to a Range
21:03 Deleting Shapes
23:24 Adding a Basic Shape
27:13 Inserting a Picture
31:48 Resizing a Picture
33:10 Drawing a Button
36:14 Adding Multiple Shapes
39:43 Adding Multiple Rows
42:13 A Quick Summary and What's Next

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 52.1 - Introduction to Shapes канала WiseOwlTutorials