none
Data (Date format) selection using either inputbox or calendar. RRS feed

  • Question

  • I have imported a text (*.txt) file to excel spreadsheet with specific recordings depending on time. Clearly speaking, one column contains date (dd-mm-yyyy tt:mm) and the rest of columns (an array) different values of interest.

    I want to create a chart (using macros) with horizontal axis as the period of time which user would be able to specify in the inputbox and with the vertical axis of the certain value depending on that particular period of time (the range of time that user have selected in the inputbox).

    I don't want the user to have to highlight the cells because there are just to many. 
    Basically I only want to graph the portion of the data.

    Example: The user determines he/she wants to see the data from 04-06-2013 21:32 to 04-06-2013 23:44 (Just portion of whole data from spreadsheet)

    Is there any way to ask for an input such as 'start' & 'stop' so the user inputs '04-06-2013 21:32' & '04-06-2013 23:44' and excel can select the range of cells, for example as B341:B354. And use the range later to plot the chart?

    8 04-06-2013 23:38 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:38 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:38 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:39 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:39 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:39 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:39 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:39 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:40 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:40 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:40 0 1 37,98885 37,98885 63,92529 31,3809
    8 04-06-2013 23:40 0 1 37,98885 37,98885 63,92529 31,3809
    Sunday, December 14, 2014 9:00 AM