Hi,
I have a problem. I want to place a Radio Button Group and other controls on an embedded chart in a worksheet.
When controls and Chart are not grouped together the code works but when I click on a Radio Button, the Radio Button Group disappear in the background of the chart.
I have to group the chart and the controls together but then I don't know how to activate the chart from the code. I get error messages...
The code that works before grouping chart and controls together:
Code
Sub Chart_Line()
ActiveSheet.ChartObjects(1).Activate
ActiveChart.ChartType = xlLineMarkers
End Sub
Sub Chart_ColumnC()
ActiveSheet.ChartObjects(1).Activate
ActiveChart.ChartType = xlColumnClustered
End Sub
Display More
Please help me with this. I have not created the chart in VBA and I just want the Radio Button Group to work. Because of design matters I want to place the Radio Button Group and other Controls on the Chart Area.
Regards
prsthlm