Results 1 to 2 of 2

Button to time stamp a row in excell worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2013
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Button to time stamp a row in excell worksheet

    My goal is to allow any shared user of a workbook to 'time stamp' the time they started an assigned task. So for row 1, the persons name is in A, column B has a TIME button, column C a non-volitile time stamp (which would be the result of pressing the time button in B), D I'll have a drop down list of tasks and based on estimated times for tasks an ETA of their return in E. The goal is to allow all users to stamp the time they or another takes out an assigned task and to use the sheet for workload planning on when to expect someone back. Hope that makes sense.

    So i first tried with forumlas, but of course they refresh (volitile) so that didnt work. Then i tried VBA but couldnt ever get it to work in multiple rows. I got it to work in one row, but couldnt duplicate.

    Can someone help me with the suggested VBA code as I'm starting fresh at this point? And then guide me on how I need to create individual active x buttons for each row, so when someone presses it they only update the time in that row? Only 10 rows needed total, so it shouldnt get too cumbersome to create manually I would think.

    Hope this makes sense, I'm not a novice, but not advanced either. I appreciate your help.
    Last edited by burdenpi; 07-13-2013 at 01:39 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Button to place a time stamp, save the file, and exit
    By Taiter in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-20-2013, 12:48 PM
  2. Excel VBA find newest worksheet based on date/time stamp in worksheet name?
    By takchin.tc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2012, 03:56 PM
  3. [SOLVED] renaming new worksheet with time stamp and text
    By beckdog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2012, 05:00 PM
  4. Modifying a Macro Button to time stamp when the button was clicked.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-22-2010, 04:46 PM
  5. Command Button Date/Time Stamp
    By sky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2006, 08:10 PM

Tags for this Thread

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