How do I modify text via vba to a button on a excel chart

[spurs]

I have an excel xy scatter chart in the worksheet "Plot"

Is it possible to create a cell on this plot worksheet where i can enter a value that can be read in by vba code

The plot moves based on the numerical value entered. Currently that value is in another worksheet but i would prefer to enter it on the plot without switching tabs

 

[tj4242]

Does something like this work? Obviously A2 is just an example.

plot_value = Worksheets("Plot").Range("A2")

 

[spurs]

Does something like this work? Obviously A2 is just an example.

plot_value = Worksheets("Plot").Range("A2")

I dont follow what you are trying to do

I want some sort of box or cell shown on a chart that allows me to enter a value and then that value will be transferred to another worksheet

 

[tj4242]

That is VBA code that takes whatever you enter on Worksheet Plot, cell A2 and places in a variable called plot_value. You can now use plot_value for whatever you need on whatever worksheet you need to.

 

[spurs]

That is VBA code that takes whatever you enter on Worksheet Plot, cell A2 and places in a variable called plot_value. You can now use plot_value for whatever you need on whatever worksheet you need to.

The chart "plot" is on its own sheet and is not an embedded object in a worksheet.
How do i add a single cell on that chart which allows me to enter without using a input box type method with a control button initiation. That is too slow