I am not good at Excel but I know Visual Basic v6. I want to write text to an existing textbox on an Excel scatter chart. Thr word I write depends on the result of a calculation in a sub in VBA module Macro1. One new word will replace the existing word.
There is only one worksheet and one chart. How should I write to the existing textbox on the chart on the worksheet? I would appreciate knowing the Dim, Set, and assignment statements.
There are two textboxes to change - "Textbox 1" and "Textbox 2". The chart name is "Chart 2". The worksheet tab name is "SamplingPlan"
Using - MS Office Professional Plus 2016