Excel VBA Objects: Shape Object (Part 1)
Get the Excel VBA Objects Guide for Intermediate with extended and revised content here: https://excelmacroclass.blogspot.com/...
Welcome to the Excel VBA Objects Series. In this video we see how to work with the Shape object. We learn to target and reference the Shape object in a worksheet, what are the different types of shapes and auto shapes in Excel and Microsoft Office, how to add a shape, and how to format the shape. In the next video we'll see how to add and format other shapes, and how to target specific types of shapes and delete a particular shape or all shapes in a worksheet.
MsoAutoShapeType Enumeration here:
https://excelmacroclass.blogspot.com/...
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: https://excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (https://excelmacrofun.blogspot.com/)
Excel Macro Business (https://excelmacrobusiness.blogspot.com/)
Excel Macro Sports (https://excelmacrosports.blogspot.com/)