+ Reply to Thread
Results 1 to 3 of 3

How to record current time, without vba

  1. #1
    Registered User
    Join Date
    11-02-2010
    Location
    Upstate New York
    MS-Off Ver
    Excel 2004, 2008, 2011
    Posts
    1

    How to record current time, without vba

    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

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: How to record current time, without vba

    I think you're going to need VBA for this.

    Just a couple of macros like this:

    Please Login or Register  to view this content.

    They can easily be attached to a button from the Forms toolbar. Just change the sheet name and cell references as required.

    The code should be placed in a regular VBA module. See here for info.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: How to record current time, without vba

    Something about creating forms too: http://www.contextures.com/xluserform01.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1