×

VBA Graphics

VBA Code To Save As Picture in Excel

VBA Code To Save As Picture in Excel

Not As Easy As You’d Think… One would think that saving something as a picture file (png, jpg, etc…) inside...

Adding A Logo or Image To A Spreadsheet Header/Footer

Adding A Logo or Image To A Spreadsheet Header/Footer

What This VBA Code Does If you are using Headers or Footers for your spreadsheets, the chances are you're going...

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 Code To Insert An Image Into A Cell Comment

VBA Code To Insert An Image Into A Cell Comment

What This VBA Code Does Using screenshots inside a cell's comment box is a neat little trick I like to...

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...

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...

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...