I am currently writing one of my first VBA applications which is used to display different Charts. The source data for the charts is contained in a worksheet. I would like to be able to display the charts on a Userform but don't know how to!!
I have tried placing it in Frames, Image Boxes and Chart area object using the following code, but this does not work! ...
ActiveChart.Location Where:=xlLocationAsObject, _ Name:=FrmGraph.ChtGraphArea
Is there a way to display charts in Userforms? Please help. Thanks