Excel Macro - Shape size desired not corresponding to correct Height and Width

Hello,

I'm trying to make an Excel Macro where a box automatically sizes to the unit dimensions (inches) the user puts in.

Attached and below is a photo that describes everything I have so far.

Pic.jpg

You'll notice in the bright blue box I have

dimension D = 20 inches (sometimes written as 20") and

dimension L = 100 inches (100").

Below is the orange box that automatically resizes to these dimensions (or... it should be that is ). Below this box is the macro code for the sheet.

Now at the very right, you'll see the FORMAT SHAPE settings for this orange box. Next to Height and Width, you'll notice that the numbers don't match the values that the user inputted.

In the middle is where I was trying to figure out why... Apparently, even though I'm putting in 100" for dimension L, the Width value being put in is following a formula: Width = 0.01391*(Dimension L)-0.0024

For dimension D, its doing the same thing: Height= 0.01391*(Dimension D)-0.0024

How can get the user inputted dimensions to match the dimensions in the box settings? I feel like I'm really close but I'm having trouble figuring out the last step it seems.

Hi there,

Try using:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Greg M,

Thank you! That is just what I needed!

Respectfully,
Owen T

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M