Hi
I wouild like to include in my EXCEL-VB program diagrams which are the result of the calculation.Also During input I would like to create some simple form like I beam, WF beam .The size should be the result of the user imput parameters.
Any suggestion, advice, book titel welcom.
Have programs from Germany with fantastic animation, but useless in North American Code.
Thanks
Ernie

Excel drawing tools can be static and with a bit of getting to know the drawing tools you can pretty much draw anything. This may be of help.

For drawing that dynamically change in response to an input you need to use the charting tools (usually the x-y scatter chart). There are quite a number of spreadsheet on this site that use this approach. Some examples that spring to mind are bolt group or a weld group.

Once you have created a chart you can easily animate it using the animator button on the XLC toolbar.

I hope these are useful to you Ernie. I am very keen to help people wishing to upload so please ask if you need any further help.