No Excel Help in VB6 IDE

[JimWyseTech]

I'm running VB6 under Wiondows 11, quite happily, except, when adding Excel terms to my VB6 code, I cannot get any Help, (F1), for any of the Excel terms.

Here's an example:

  With xlChartObj.Chart
                .SetSourceData Source:=ActiveSheet.Range("A2:D26")
                .ChartType = xlXYScatterLines
                .HasTitle = True
                .ChartTitle.Text = "Room Temperature"
                .HasLegend = True
                .Legend.Position = xlLegendPositionBottom

If I select, for example, the ".Legend.Position", then F1, I get

"Unable to display help", with an OK and a Help button.

I get the same result for selecting any of the terms that begin with "."

I'm guessing I have a path definition missing, but which, and where?

Thanks to anyone who can help

Jim

[Elroy]

The Excel object hierarchy isn't in the VB6 MSDN. To get that, you have two approaches: 1) find a copy of the old VBAXL10.CHM and then struggle to get that to work on your computer, or 2) go to https://learn.microsoft.com/en-us/of...l/object-model and use the online Excel VBA help (and this is probably the better of the two options).

[gigemboy]

I second this.

https://learn.microsoft.com/en-us/of....chart(object)

[Zvoni]

And i would be surprised shown code compiles in VB6

With xlChartObj.Chart
.SetSourceData Source:=ActiveSheet.Range("A226")
.ChartType = xlXYScatterLines
.HasTitle = True
.ChartTitle.Text = "Room Temperature"
.HasLegend = True
.Legend.Position = xlLegendPositionBottom

[JimWyseTech]

Why?

Seems correct to me, and compiles quite OK.

[KeepUsingVB]

I agree with Elroy the VB6 IDE which is a standalone VB editor it and help is no longer supported by Microsoft and attempting to use Microsoft Office VBA coding linking to help for Excel appears is not supported.

One way you can get some help is to create and troubleshoot your code using it in an Excel UserForm or module in Excel.

Create the objects and Set the value for your objects in the userform and when you code the object parameters in the userform F1 will open the Excel help for the parameter.

Hope this helps.

[Zvoni]

You all assume this is written in VB6

i wouldn't be surprised if above is actually written in VBA in Excel,
because an alone standing "ActiveSheet" is a red flag to me.

If it were written in VB6, it assumes he has a reference to the Excel-Objects (Late Binding not withstanding), but then he gets into Namespacing, which starts at the Workbook (I'll ignore "Excel-Application")
So, an alone standing "ActiveSheet" should never be able to compile in VB6

EDIT: Now would you look at that. OP's next thread is in the Office-Forum, and it's about........ Ta Daaaa: VBA