VIDEOS BY CATEGORY
VBA - WORKING WITH SHAPES VIDEOS
VIDEOS BY AUTHOR
Training videos for learning VBA - WORKING WITH SHAPES
VBA - working with shapes - 3 videos
Posted by Andrew Gould on 06 February 2017
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.
Posted by Andrew Gould on 16 February 2017
You can add text to most shapes that you can draw in Excel. This video explains the basics of working with text in shapes, including how to add to text to a basic shape, how to format text inside shapes and how to change the text alignment and orientation.