That's funny, when I tested it I downloaded the zip, extracted the xls, and
ran it as is. I also copied the code from the web site and pasted it into an
Excel 2007 module. Both worked as expected. I don't understand your
difficulty, but at least you got it working.

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


"turen" wrote in message
...
Jon,

I got it now. Previously I was using your instruction sheet to do the
work
and that did not work. After I copied your vb script to a new workbook.
it
worked.

I am a newbie and just begin to learn Excel programming. Thank you so
very
much.

Turen

"Jon Peltier" wrote:

This worked fine in a test I just ran. Did this work for you in Excel
2003?

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


"turen" wrote in message
...
I am trying create a chart 'on the fly' based on the user selected data
range
in Excel 2007. I was trying to use Jon Peltier's 'interactive chart
creation' VB scripts. Somehow it does not work on Excel 2007. After
Jon's
interactiveChartCreation.xls opens, both input boxes does not work,
meaning
one can not input any data by mouse selection. I tried to click 'ok',
but
it
only selected the input box. I hope Jon or some one else can see this
and
offer some help. Thank you all very much for your tips.