I created a graph and inserted it as a new sheet that is named "Graph". On
this chart, then placed a textbox. I would like to know if there is a way in
VB to update this textbox with the results of calculations that are done
within a
VB routine. In VB6 it was simple to do Textbox1.text = "Some Text",
but I don't seem to be able to do the same in
VB for Excel. I have tried
Sheets("Graph").textbox1.text, Chart1.textbox1.text, etc but with no luck.
Can someone provide help with this.
Thank you
Vince