+ Reply to Thread
Results 1 to 4 of 4

Insert time stamp on double click

  1. #1
    Registered User
    Join Date
    03-05-2014
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Excel 2003
    Posts
    34

    Insert time stamp on double click

    Hey all, I'm trying to have excel insert a timestamp on a specific range of cells. I have it currently working on one cell, but can for some reason am having trouble getting it to work on the entire range... Here is what I have currently...

    PHP Code: 
    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As RangeCancel As Boolean)
    If 
    Target.Address "$E$23" Then
    Target
    .Value Time
    End 
    If
    End Sub 
    I would like this to work for the range E23:E28 and F23:F28 I'm sure its something simple that I'm not doing... any help?

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Insert time stamp on double click

    if not intersect(target,range("e23:F28")) is noting

    end if
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Insert time stamp on double click

    Hi,

    Please Login or Register  to view this content.
    Regards
    Miroslav R.

    (If You like my solutions, feel free to add reputation.)

  4. #4
    Registered User
    Join Date
    03-05-2014
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Insert time stamp on double click

    You guys are awesome, thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Double click cell to insert current Time
    By Vetequk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-17-2013, 10:30 AM
  2. [SOLVED] Double Click to Insert New Row - Please Help!!!
    By JohnHIII in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2013, 05:09 PM
  3. Auto fill Date + Double click (time stamp)
    By SVTF in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-05-2012, 03:29 PM
  4. Insert Date & Time to a neightbouring column when I double click in column A
    By contaminated in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2011, 12:05 PM
  5. double click row to insert new row
    By SurferBobInHb in forum Excel General
    Replies: 3
    Last Post: 03-25-2009, 04:47 PM

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