Not As Easy As You’d Think… One would think that saving something as a picture file (png, jpg, etc…) inside...
What This VBA Code Does If you are using Headers or Footers for your spreadsheets, the chances are you're going...
What This VBA Code Does I recently needed to create a VBA function that tests if a particular shape object...
What This VBA Code Does The following VBA code will provide you with a way to delete all shapes from...
Lately, I have been writing a lot of VBA code dealing with the creation of shapes and managing them. I...
What This VBA Code Does Using screenshots inside a cell's comment box is a neat little trick I like to...
What This VBA Code Does The following code will show you how to take the currently selected shape in an...
What This VBA Code Does This VBA code is a nifty little I created to solve the hassle of selecting...
Transferring VBA Through Worksheet Objects The easiest way to copy over VBA code while copying your worksheets into a new...
What This VBA Code Does This VBA code looks for any shape within the ActiveWorkbook with a specific name and...
What This VBA Code Does Shadows have 5 characteristics that do not easily translate from the slide view into VBA...
What This VBA Does I could not find any way to call the Excel-based alignment actions with VBA, so I...
What This Does There are times when you would like to know information about the currently selected shape on your...
What This Does Ever have an instance where you have a TON of shapes or images on your spreadsheet and...
What This VBA Code Does This will reference a specific textbox on a worksheet and add multiple lines of text to...
What This VBA Code Does This code allows you to lock and unlock the Aspect Ratio of a shape or...
What This VBA Code Does This VBA macro has a ton of great stuff! First it creates a shape and...
What This VBA Code Does This VBA code will apply a custom border to all the pictures in your Word...
[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!