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
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