Dynamic Chart in VBA Form

alion

New Member
Joined
Aug 4, 2011
Messages
19
Dear Experts,
I am designing a VBA application for finance. It extracts data from the web and calculates certain index based on the information. I found a way to create a dynamic macro based chart in excel worksheet which incorporates new information but I want it to appear in user form. I tried using Microsoft Chart 11.0 but it is asking me to input data which makes it static. I want to make sure that user gets everything in useform rather then moving from excel to VBA and vice versa.

Can anyone please help?

Thanks in advance.

Ali
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Thanks man. I tried it but it is giving me runtime error 9, script out of range on

Set CurrentChart = Sheets("Sheet1").ChartObjects(1).Chart

I have one chart on sheet1 and i am using this code on a module under 'sub' and calling this module using command button. I know i suck at this. please let me know where is the mistake. thanks
 
Upvote 0
That means that there is no sheet called "Sheet1" or no chart objects on Sheet1.
 
Upvote 0
guilty.... sheet name was incorrect. I thought changing caption wont matter. It works like charm now. Thanks alot.
 
Upvote 0

Forum statistics

Threads
1,224,527
Messages
6,179,345
Members
452,907
Latest member
Roland Deschain

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top