Training videos for learning VBA - WORKING WITH SHAPES

We have 5 VBA - working with shapes videos listed below. You might also like to consider booking a place on one of our online or classroom VBA courses, where you will meet the owls behind the 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.

How do I draw a line in a cell in Excel VBA?

Posted by Andrew Gould on 07 January 2022

This video shows how to use VBA to draw lines on an Excel worksheet and position them relative to cells. You'll learn how to set the X and Y co-ordinates of the line start and end, and how to reference the Left, Top, Width and Height properties of a cell to control the position of the line.

How do I save a shape as a picture in Excel VBA?

Posted by Andrew Gould on 05 February 2022

Annoyingly, there's no quick, built-in way to save a shape object as a picture in Excel VBA, even though you can use a context menu option to do this easily in Excel! This video shows a slightly messy workaround in VBA which involves copying the shape into a temporary chart to make use of its Export method!

This page has 0 threads Add post