Formatting Width and Length of Shapes

Bumping in hope to find a helping hand for this.
Thanks!

Hi all,

Hoping to get a helping hand for this problem.
Thanks!

Originally Posted by Andy Pope

you can use a user defined function

Please Login or Register  to view this content.

Pardon me due to my limited skills in Excel,
How do I assign this to the "Rectangle"?
Do I go to "Assign Macro"?

Originally Posted by Andy Pope

I thought I had attached an example.

You can use the udf in a cell.

My apologies I must have missed that.

I had tried applying the exact same given as your example into my template however i got the error ###### (as shown in cell C25)
As attached is what I am working on and hope you will be able to help me see what I had done wrongly.
What I want to achieve is the rectangle box to size according to the values given in W and L so that I will be able to see if the box will be able to fit into the pallet (as highlighted using conditional formatting).

Cheers!

Originally Posted by Andy Pope

You need to add the function to the workbook otherwise it will not work.

You may need to convert those values to to the correct scaling for shapes.
The routine is using the value as the points size for width / length

I tried navigating around with a new excel sheet but could not find any way to add in the function.
Will it be possible to explain step by step in details? (I am really weak with excel)
Sorry to be causing trouble as I will need to explain it out instead of just blindly taking and using the new template you had already done it for me. ><

Roger that!
Thanks alot Andy!
Really appreciate your help much! ^^