F
fizbim
I have added a "Microsoft Excel Chart" object to a form, then sized th
chart to fit the form. The chart has been modified to show the prope
axis labels, scaling, etc. In effect, creating the template.
The Excel Chart has a "Chart" tab and a "Sheet1" tab where the Sheet
tab is the actual worksheet for the chart plot data. My problem i
filling in "THIS" worksheet with data from my array. I cannot find an
object reference to an Excel worksheet in my project. The Excel Char
object only has parameters for height, width, top, bottom locations
etc.
As a stab in the dark, I tried this code segment to attempt to fill th
worksheet with no success.
For r = 0 To 1400
Worksheets("Sheet1").Cells(r + 1, 1) = r
Worksheets("Sheet1").Cells(r + 1, 2) = TripData(1, r)
Next r
How do I access the worksheet portion of an Excel Chart object that ha
been added to a form ?
Thanks,
Fi
chart to fit the form. The chart has been modified to show the prope
axis labels, scaling, etc. In effect, creating the template.
The Excel Chart has a "Chart" tab and a "Sheet1" tab where the Sheet
tab is the actual worksheet for the chart plot data. My problem i
filling in "THIS" worksheet with data from my array. I cannot find an
object reference to an Excel worksheet in my project. The Excel Char
object only has parameters for height, width, top, bottom locations
etc.
As a stab in the dark, I tried this code segment to attempt to fill th
worksheet with no success.
For r = 0 To 1400
Worksheets("Sheet1").Cells(r + 1, 1) = r
Worksheets("Sheet1").Cells(r + 1, 2) = TripData(1, r)
Next r
How do I access the worksheet portion of an Excel Chart object that ha
been added to a form ?
Thanks,
Fi