Hi TAPIE,
I have just tried your Excel spreadsheet. It works normally in my computer.
In your code, a chart is created when the user clicks on the Form. I run your Excel code and click on the form, and a chart is created immediately.
Would you mind to try once more? Make sure you are clicking on the Form, and not on the ChartViewer. It is because your code only handles the click event of the Form. Because the ChartViewer covers almost the entire form, therefore, you must click on the top or left edge of the form. I suggest you click on the top left corner of the form, to make sure you are really clicking on the form (and not on the transparent ChartViewer).
Alternatively, you may put a push button on the form, and clicks on the push button to create the chart. In this way, it is easier to know where to click.
Hope this can help.
Regards
Peter Kwan |
Forum Home
Search
Message List
Post Message
(TAPIE Pierre) 
PB Chartdirector with VBA