dynamic chart on user selected data range in Excel 2007

[turen]

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.

 

[Jon Peltier]

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

- Jon

 

[turen]

Jon,

Thank you very much for the reply. I don't know if I did something wrong.
What I did was to download your InteractiveChartCreation.zip file and extract
it. After I opened interactiveChartCreation.xls and enabled macro, I used
mouse to drag a region where I want the chart to be drawn, then click 'ok' in
the 1st input box, but everytime I moved my mouse pointer to the input box,
it showed a 'select icon' (four arrows in up, down, left and right
direction), so I end up selecting the input box object and nothing happened.
The same happened when I selected the data in the 'data sheet' and tried to
click 'ok' in the 2nd input box. Did I do something wrong? Thank you very
much for your time. I don't have other excel version to try.

 

[turen]

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

 

[turen]

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]

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