I would suggest using something like these approaches:

http://www.j-walk.com/ss/excel/tips/tip66.htm
http://oaltd.co.uk/DLCount/DLCount.a...stePicture.zip

(the first is probably much easier) and have the chart put back on the form
whenever the worksheet data changes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"pinkfloydfan" wrote in message
ups.com...
Hi there

Working with Excel 2003:

Am I correct in thinking that by adding to the userform controls
"Microsoft Office Chart 11.0" you can add a live chart to the
userform?

My immediate project is to create a userform that allows the user to
set the inputs for a class. As the inputs are changed (maybe with a
spinner) the chart on the userform changes to reflect the updated
class inputs. Thus, the user can adjust the inputs until they get the
shape they are looking for.

Am I heading in the right direction here?

Thanks
Lloyd

p.s. what does "modeless" mean?