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.


    Regards,


    Tom Rowe...