Editing graphs in VBA Excel at design time

[QuijoteMx]

Hi!

I've been using tchart activex since version 8 in VB6 enviroment and now have to migrate some graphs to Excel under VBA. It is not a big deal to do that, but I'm relizing that I can't edit the graph at design time.

In VB6 environment, right click on tchart control pops up a menu with the edit option that invokes the edit dialog, so you can add series and configure your graph using the dialog. I'm trying to do the same action on VBA for Excel but although there is a pop up menu, when you rigth click the tchart control it does not have the edit option.

Is this control behavior expected under VBA under Excel, or I did a mistake in the installation, or the edit dialog is available through other procedure. I'm using Excel 2013 under Windows 10.

Does anybody have the answer ..?



Thanks,

QuijoteMx

[Yeray]

Hello,

Please make sure you have the "design mode" activated in Excel:

2021-04-01_13-19-35.png (70.2 KiB) Viewed 38853 times

Then you should be able to open the options menu right-clicking on the chart.

[QuijoteMX]

Hi!
Thank you Yeray.

I followed your hint and works perfectly for embedded graphs on Excel sheets.

Sorry, but what I was trying to do is editing graphs on user forms in vba.

I turned on the developers mode prior to trying to edit graphs in user forms without success.

This functionality is what I'm looking for. As you can see, the developers button is turned on but no edit option appears in the pop up menu of the tchart control.

Is there something wrong with my software installation, or I'm not looking in the right place ...?

[Yeray]

Hello,

You can open the editor through the properties:

usercontrol.png (77.09 KiB) Viewed 38765 times

[QuijoteMX]

Thank you Yeray ...