View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vince Vince is offline
external usenet poster
 
Posts: 102
Default Textbox question

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