Given that the chart is on a sheet of its own and your code assumes it
is the ActiveSheet, using Range("A1") to adjust a chart property won't
work (gives me a run-time error 1004). You need to qualify it, e.g.
Sheets("Sheet1").Range("A1").

Could you please explain how i would convert the
textbox value from text to number?

Assign it to a variable declared as a number (Integer, Long, Single,
Double) or use a convert function CInt(), CLng(), CSng(), CDbl(),
Val().

Merjet