Hi Everyone!

I am looking to create a tool in excel where a user can enter the length, width and height of packaging that they ship in and a rectangle shape will automatically adjust to those dimensions. From the research that I have done on Google I can see that the biggest challenge is the getting the length to display properly. I am hoping that there is some type of manipulation that can be done with the 3D formatting to make a shape dynamic based on when a user changes the values in cell A1, A2 and A3.

I know that different software would accomplish this easily...but I believe that if we could incorporate this feature into our existing excel reports that it would add a lot of value.

Essentially I want someone to enter L, W & H and be able to visualize what that packaging looks like (ie. odd shaped, tall etc)

Any thoughts on how this can be accomplished? I know that the Worksheet_Change sub will have to be used but I'm just not sure about the code that can make the object 3D and proportionate to the dimensions I am entering.

Would it be easier to attempt to do the same thing on and MS Access Form?

Thank you in advance for the help.