Aspect ratio of a Comment image

[Michael Singmin]

Hello Group,

This is a difficult question on Comments because the renowned expert
on Comments, Debra D, has not found a solution, yet.

I am creating an art gallery in a worksheet. Because Comments are so
economical in storing images, I want to use this method.

Fine art comes in all shapes and sizes.
When the art arrives in the comment, the shape is roughly square.
I have to manually reshape it to get it back to its original aspect.

Is there any VBA code that will achieve the same ?

Thanks,

Michael Singmin

 

[Tom Ogilvy]

Import the image as a picture

get the height and width

set the comment height and width to match

delete the imported image

 

[Michael Singmin]

Well done Tom,

Your pseudo code was perfect because I leant very much more.
Besides getting the perfect solution for my project, I also learnt
how to get the parameters of a picture and how to feed them
into the comment image. I also gained valuable insight into counting
shapes, counting pictures and objects.

Much appreciated,

Michael
==========================================================

 

[Tom Ogilvy]

Great feedback - and great initiative. You are an inspiration to all!