[Guy Havet]

Hello Jon,
Thank you for the fast answer.
This is a good tip for inserting a chart picture in the form
unfortunately it is not a chart dynamically linked to the data of the
spreadsheet.
I do need to work out the ChartSpace and Chart objects in the VB form.
So recording macros won't do the trick either. I have tried quite a few
things of that nature already.
If you work this thing out keep me posted.
Thanks
Guy



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Tom Ogilvy]

Define the term form.

Are you talking about a form in VB6 (the application development language as
opposed to VBA in excel)
Are you talking about a "form" being a worksheet in Excel that looks like a
paper form
Are you talking about a userform in Excel using VBA

Regards,
Tom Ogilvy


Guy Havet wrote in message
...
Hello Jon,
Thank you for the fast answer.
This is a good tip for inserting a chart picture in the form
unfortunately it is not a chart dynamically linked to the data of the
spreadsheet.
I do need to work out the ChartSpace and Chart objects in the VB form.
So recording macros won't do the trick either. I have tried quite a few
things of that nature already.
If you work this thing out keep me posted.
Thanks
Guy



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!