Combo Box and automatic treatment


New Member
Aug 26, 2014

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,

Forum statistics

Latest member
ndaines meriabi

Some videos you may like

This Week's Hot Topics