Results 1 to 2 of 2

Thread: Auto Date

  1. #1
    Join Date
    Sep 2012

    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
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    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.
    Beers earned: 2

Posting Permissions

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