Combo Box and automatic treatment

[Daxatak]

Hi,

I would like to create a VBA script that allows me to organize and compute (and plot graph) different things depending on the sheet I select.
To be more precise:
I got (a lot of) different excel files (different months) with different sheets (different weeks in the months) with the same formatting (date, time, and my.value).
I already created a script that allows me to extract the interesting data of all those sheets in the same sheet.
but now, I would like to use a Combox box, that allows me to select a sheet and to have all the interesting data about it (+ graphs) in the same sheet.

My (first) problems are:

• I don't know how to be able to implement the fact that all the modifications have to be done depending on the choice on the conbo box.
  • If I select "Tuesday" I would like to have automatically All my resutls + graphs updated for this day
  • + If I select a specific time interval, I would like to have the same update for this interval (2 "time & date" inputs that are automatically modyfing the output)
• I don't know how to deal with graphs in VBA
• I am quite sure that the solution will be a mix between VBA and a dashboard, but I am not sure to understand how I can relate both.
  • Or how to create a dashboard (that would allow me to control the different parameters) with VBA...

I realize, this is really fuzzy, but I would really appreciate any input concerning different aspects of this problem.

Thanks in advance for your time,
Damien