Hi Merjet


Thanks once again for your assistance.

The chart is in a sheet of its own, when i make recorded changes the code
all begins "ActiveChart.". Could you please explain how i would convert the
textbox value from text to number?

Many thanks


jb

"merjet" wrote:

I tried manipulating a chart on a worksheet and one on a sheet of its
own using cell values. Both worked fine, but I had to specify the
sheet for the latter. Of course, if you use a value from a Textbox,
you should convert it from text to number.

Merjet