following information demonstrates how to create your first Excel ActiveX Charting implementation. It discusses installation, adding ProEssentials
to a sheet, writing your first few lines of code, and shows the final
This walkthrough uses 32 bit ActiveXs so this examples is for MS Excel 2013 32 bit.
ProEssentials, the setup program installs
the ProEssentials DLL and ActiveX interfaces into the system directory.
program also registers the ActiveXs with the operating system, which prepares
MS Access, MS Excel, Visual Basic for inclusion of ProEssentials components. You can manually
register an ActiveX with "REGSVR32.EXE" found in your system32
or syswow64 on 64 bit systems. You can also use this utility to manually un-register an ActiveX
by using the "-u" command.
From the New menu, create a new Fitness tracker spreadsheet from list of templates.
The sheet opens showing the Fitness tracker template.
Right click the top menu, select Customize the Ribbon... then select the Developer check box to enable the Developer top menu.
With the Dashboard sheet showing...
Now click 1 Developer menu, 2 Insert Menu, and 3 the More Controls icon as shown below..
This opens the More Controls dialog showing all ActiveX controls registered on the system.
Note both ProEssentials v7 and v8 setup EXEs have been installed
as both v7 and v8 are showing within the list of controls.
Highlight the Gigasoft Pego v8 control and select OK. This places the control on your sheet.
|Adding chart to the sheet...|
Referring to below image, delete the existing chart and position the ProEssentials chart in place.
Toggling Design mode off and on will allow chart to redraw itself.
|Adding Worksheet Activate event...|
Select Developer, and then View Code menu item to show the VB Code Editor.
Adjust the list boxes above code window so 'Worksheet' and 'Activate' items are shown. Then add the code below within the Activate event. Refer to image below showing the Excel VB code window.