A similar thread came up not long ago about running a script based on mouse movement:
http://www.excelforum.com/excel-prog...-activity.html

It seems quite complex though. Have you considered an input box in your macro? The user could start the macro and then be prompted to fill in a value for the cell which could then be used as a value in your code.