+ Reply to Thread
Results 1 to 6 of 6

Auto date in adjacent cell

  1. #1
    Registered User
    Join Date
    08-09-2018
    Location
    UK
    MS-Off Ver
    365
    Posts
    7

    Auto date in adjacent cell

    Hi, new to VBA so any help would be appreciated.

    I'm using VBA to populate an auto date in an adjacent cell. I've used this code and it seems to work well

    Please Login or Register  to view this content.
    However, I want this to happen multiple times in the spreadsheet, eg at the moment typing in column I populates the date in J, but I also want typing in E to populate the date in F, typing in G to populate the date in H etc.

    I can't seem to get this to work, I've tried a number of things but it just invalidates my initial code. I'm completely new to all of this so maybe I'm missing something obvious, so any help at all would be massively appreciated!!!
    Last edited by ejames10; 08-09-2018 at 03:54 AM. Reason: Code

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    14,551

    Re: Auto date in adjacent cell

    Change to
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-09-2018
    Location
    UK
    MS-Off Ver
    365
    Posts
    7

    Re: Auto date in adjacent cell

    That worked perfectly, thank you very much!

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    14,551

    Re: Auto date in adjacent cell

    You are welcome and thanks for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  5. #5
    Registered User
    Join Date
    08-09-2018
    Location
    UK
    MS-Off Ver
    365
    Posts
    7

    Re: Auto date in adjacent cell

    Sorry, wondering if you could help again...

    I've now migrated to Office 365, and this code has stopped working? I haven't changed anything within the code, I've just gone to use it and it's no longer populating an auto-date in any cells.

    I've tried other codes and nothing seems to work for any function, am I missing something? Any help would be hugely appreciated!

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    14,551

    Re: Auto date in adjacent cell

    Upload your workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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