I am designing a worksheet for entry of survey data by survey subjects. In order to record the amount of time spent filling out the form, I want subjects to begin the survey with a required action that automatically records the date and time. Then I want them to do the same again at the end of the survey. (The elapsed time is what I'm really after, so it doesn't matter if the actual times recorded are offset from the real values)
A search of this impressive forum turned up a macro which offers users a button to click. I assume that it's in VBA (I don't know VBA but can learn it if necessary)
However, can something similar to this be done without VBA? Our research subjects will be using all versions of Excel on their own computers, including the Mac versions lacking VBA.
Would also appreciate pointers to good introductory articles on designing data entry forms.
Many thanks,
susato
Bookmarks