×

Shapes

VBA Coding For Shapes (The Complete Guide)

VBA Coding For Shapes (The Complete Guide)

VBA Coding With Shape Objects In this comprehensive guide, you will be learning all the ways you can create and...

VBA Function To Determine If A Shape Has A Gradient Effect

VBA Function To Determine If A Shape Has A Gradient Effect

What This VBA Code Does I recently needed to create a VBA function that tests if a particular shape object...

VBA To Delete All Shapes On A Spreadsheet

VBA To Delete All Shapes On A Spreadsheet

What This VBA Code Does The following VBA code will provide you with a way to delete all shapes from...

How To Keep Track Of Your Shapes Created With VBA Code

How To Keep Track Of Your Shapes Created With VBA Code

Lately, I have been writing a lot of VBA code dealing with the creation of shapes and managing them. I...

VBA Set Shape Variable To Selected Shape

VBA Set Shape Variable To Selected Shape

What This VBA Code Does The following code will show you how to take the currently selected shape in an...

Group All Shapes Within A Selection Of Cells

Group All Shapes Within A Selection Of Cells

What This VBA Code Does This VBA code is a nifty little I created to solve the hassle of selecting...

Correcting Shape Assigned Macro Links After Copying Worksheet VBA

Correcting Shape Assigned Macro Links After Copying Worksheet VBA

Transferring VBA Through Worksheet Objects The easiest way to copy over VBA code while copying your worksheets into a new...

VBA Code To Add An In-Spreadsheet Hyperlink To A Picture Object

VBA Code To Add An In-Spreadsheet Hyperlink To A Picture Object

What This VBA Code Does This VBA code looks for any shape within the ActiveWorkbook with a specific name and...

How To Determine Shadow Settings of A Shape With VBA

How To Determine Shadow Settings of A Shape With VBA

What This VBA Code Does Shadows have 5 characteristics that do not easily translate from the slide view into VBA...

Determine The Current ActiveShape In PowerPoint With VBA

Determine The Current ActiveShape In PowerPoint With VBA

What This VBA Code Does This code will set a variable named ActiveShape to equal the shape that is currently...

Aligning Shape Objects With VBA Code

Aligning Shape Objects With VBA Code

What This VBA Does I could not find any way to call the Excel-based alignment actions with VBA, so I...

Determining The ActiveShape On Your Spreadsheet With VBA

Determining The ActiveShape On Your Spreadsheet With VBA

What This Does There are times when you would like to know information about the currently selected shape on your...

Adjust Object Positioning Property To All Shapes & Images On Your Excel Worksheet

Adjust Object Positioning Property To All Shapes & Images On Your Excel Worksheet

What This Does Ever have an instance where you have a TON of shapes or images on your spreadsheet and...

Reference A Worksheet Textbox

Reference A Worksheet Textbox

What This VBA Code Does This will reference a specific textbox on a worksheet and add multiple lines of text to...

Lock An Image’s Aspect Ratio

Lock An Image’s Aspect Ratio

What This VBA Code Does This code allows you to lock and unlock the Aspect Ratio of a shape or...

Create A Shape or Text Box and Format It

Create A Shape or Text Box and Format It

What This VBA Code Does This VBA macro has a ton of great stuff!  First it creates a shape and...

Retrieve The Dimensions Of A Shape In PowerPoint

Retrieve The Dimensions Of A Shape In PowerPoint

What This VBA Code Does: The VBA code below displays a message box with a selected PowerPoint item's Left, Top,...

Add Custom Border To All Pictures

Add Custom Border To All Pictures

What This VBA Code Does This VBA code will apply a custom border to all the pictures in your Word...