creating a chart in a form
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! |
creating a chart in a form
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! |
All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com