Excel 2007 : Using VBA to group a pie chart and a textbox

Hello,

[See attached image]
I am trying to group a textbox and a pie chart using VBA without luck.

The textbox (shown in the lower right corner of the attached image) has been named "DelChart" in the VBA code and the chart is the only chart on the worksheet.

I've limited VBA knowledge (I tend to create macros and try figure out what's going on then modify them as best I can) so would appreciate if someone could show me the appropriate code required.

Thanks in advance for any help or guidance.

MODS: If this properly belongs in another forum feel free to move.

If you mean group then

Please Login or Register  to view this content.

Or perhaps the textbox should be contained within the chart object.

Please Login or Register  to view this content.

Hi Andy,

I eventually figured it out by trial and error (and also viewing the code generated by VBA in Excel 2003! For some reason, Excel 2007 wasn't generating macro code for me but Excel 2003 did...????).

Thanks for coming back on this. I'll mark it as solved.

deadlyduck