VBA How to autofit image [SOLVED]

[srikandi2000]

Dear All

I am trying to insert random image and resize it to match the picture place holder (just a square as background).
I just want to make sure the image size is smaller than the picture background but still maintain the original aspect ratio, how do i approach this problem?
I hope i make myself clear.

thanks in advance

 

[vletm]

srikandi2000
You should upload a sample Excel file which would show Your needs..

 

[Marc L]

Hi !​

but still maintain the original aspect ratio

By code set first the LockAspectRatio property then amend the Height or Width property of the shape …​

​

 

[srikandi2000]

Thanks vletm and Marc. I have not write the code yet as of tuesday because I am still looking for solution that needed the least code length. Anyway, I decided to make the background square (n x n size) and then i look for the bigger number between the length and width. Then I resize the bigger number to n size. The LockAspectRatio seems to be true by default.

How do I mark this as solved?

 

[vletm]

srikandi2000
Without a sample file it's a challenge to offer valid code for Your needs.
As solved ... Try to edit Your thread-text and add [Solved] in the end.

 

[srikandi2000]

thanks, but i cant seem to find the edit thread anymore. maybe there is a time limitation