Special time based Vba request ..

  • Hey all,

    I would like to know if it would be possible to find out the time difference between last Sheet Selection Change and the current Sheet Selection Change.

    for instance I am at any given cell , in this case A4 and then after 5 seconds I decided to go to cell A5

    Could a code output me value of 5 seconds?

    Or from here on I decided to go from cell A5 to A6 in 1 second, could the code output me value of 1?

    Thank you and will appreciate.

  • Hi,

    This is relatively simple to achieve by using the Timer function which returns a Single representing the number of seconds elapsed since midnight.

    See the following code which should be inserted into your worksheet module...

    See the attached workbook 'cell_clicks_time_difference.xlsm' for the working code.


    Tom Rowe...