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
Editing graphs in VBA Excel at design time
Re: Editing graphs in VBA Excel at design time
Hello,
Please make sure you have the "design mode" activated in Excel:
Then you should be able to open the options menu right-clicking on the chart.
Please make sure you have the "design mode" activated in Excel:
Then you should be able to open the options menu right-clicking on the chart.
Best Regards,
![]() | Yeray Alonso Development & Support Steema Software Av. Montilivi 33, 17003 Girona, Catalonia (SP) |
![]() ![]() ![]() ![]() ![]() ![]() |
Please read our Bug Fixing Policy |
Re: Editing graphs in VBA Excel at design time
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 ...?
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 ...?
- Attachments
-
- edit option not available.png (240.35 KiB) Viewed 36019 times
-
- edit option available.png (221.42 KiB) Viewed 36019 times
Re: Editing graphs in VBA Excel at design time
Hello,
You can open the editor through the properties:
You can open the editor through the properties:
Best Regards,
![]() | Yeray Alonso Development & Support Steema Software Av. Montilivi 33, 17003 Girona, Catalonia (SP) |
![]() ![]() ![]() ![]() ![]() ![]() |
Please read our Bug Fixing Policy |
Re: Editing graphs in VBA Excel at design time
Thank you Yeray ...