ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Comment Box Size = 125% Fill Picture Size (https://www.excelbanter.com/excel-programming/435474-comment-box-size-%3D-125%25-fill-picture-size.html)

Jason W

Comment Box Size = 125% Fill Picture Size
 
I need a block of code that will set all of the comment box sizes on a
worksheet to 125% of the width and 125% of the height of the fill picture
sizes.

Can anyone help?

Thanks in advance.

Jason W

Comment Box Size = 125% Fill Picture Size
 


"Jason W" wrote:

I need a block of code that will set all of the comment box sizes on a
worksheet to 125% of the width and 125% of the height of the fill picture
sizes.

Can anyone help?


Let me clarify...

1) I filled multiple comment boxes with userpictures.
2) I want to adjust the sizes of the pictures to 125% their "original
picture sizes"..
3) I want to adjust the size of the comment box to match the size of the
picture..


Thanks in advance.



All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com