Results 1 to 2 of 2

Thread: Auto Date

  1. #1
    Join Date
    Sep 2012
    Posts
    2

    Question Unanswered: Auto Date

    I am looking to have column A auto populate the date statically when data is entered into column B. I would like Column A to remain blank otherwise. Can someone help with VBA code for this.
    Last edited by emsjunkie310; 09-24-12 at 17:19.

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    You probably want to write this in the relevant worksheet's OnChange event as a starting point. Check out the Column and Row properties of ActiveCell, too.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

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