Training videos for learning VBA - WORKING WITH SHAPES

VBA - working with shapes - 3 videos

Excel VBA Part 52.1 - Introduction to Shapes

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.

Excel VBA Part 52.2 - Formatting Shapes

Posted by Andrew Gould on 14 February 2017

The previous video in the series explained how to draw shapes on a worksheet - this one explains how to make them look more interesting by applying a variety of formatting effects to them.

Excel VBA Part 52.3 - Adding Text to Shapes

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.

This page has 0 threads Add post