+ Reply to Thread
Results 1 to 9 of 9

double click for timestamp and username

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    double click for timestamp and username

    Hi all,
    I have some coding which gives me what I want by double clicking in column E:
    E displays signed off
    F displays username
    G displays timestamp

    I want exactly the same thing in columns I, J and K but I can't seem to amend the code so it enables me to do this too.............please someone help!

    Please Login or Register  to view this content.
    Last edited by arlu1201; 09-24-2013 at 05:50 AM. Reason: Use code tags as per rule 3.

  2. #2
    Forum Contributor
    Join Date
    01-17-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: double click for timestamp and username

    Please Login or Register  to view this content.
    becomes
    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.

    I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.

  3. #3
    Registered User
    Join Date
    09-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: double click for timestamp and username

    Hi, thanks for the above but I need the option to do both sections in the same code.....that's what I'm struggling with.
    any ideas?

  4. #4
    Forum Contributor
    Join Date
    01-17-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: double click for timestamp and username

    Just add them under eachother then but thats rather strange or i do not udnerstand what you want.
    can you upload an example (manualy input your end result)

  5. #5
    Registered User
    Join Date
    09-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: double click for timestamp and username

    But I have already said myrange is column "e" at the beginning of the code. somehow I need to say that you can double click in either column "e" or "i". If you double click in "e" it updates e, f and g and if you double click if "i" it updates i, j and k.

  6. #6
    Forum Contributor
    Join Date
    01-17-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: double click for timestamp and username

    create a second range :
    Please Login or Register  to view this content.
    to define where to place your info update it as per below
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    09-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: double click for timestamp and username

    now if I use the code below, nothing happens if I click in e or i: there's no error messages, it just does nothing???

    Please Login or Register  to view this content.
    Moderator Note:

    Pls use code tags around your code next time as per forum rules.
    Last edited by Fotis1991; 09-24-2013 at 12:15 PM.

  8. #8
    Forum Contributor
    Join Date
    01-17-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: double click for timestamp and username

    you coded this in your first post and that makes you do nothing when E2:E100 is empty
    Please Login or Register  to view this content.
    Now when you do this for I2:I100 it will also step out and do nothing , so you have to combine them e.g. :
    and if both ranges are empty you step out , or if any range is empty then step out
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    09-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: double click for timestamp and username

    Thank you!! We used THEN and it worked!
    Cheers

+ 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. Copy double-clicked cell to next empty row in different sheet with each double-click
    By erhathaway in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-25-2013, 12:06 AM
  2. userform label double-click goes to click event
    By John Paul Fullerton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2006, 01:00 PM
  3. Replies: 4
    Last Post: 08-02-2005, 09:05 PM
  4. CommandBarButton click vs. double click
    By Derrick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2005, 05:19 PM
  5. double click
    By bforster1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2005, 11:48 AM

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