+ Reply to Thread
Results 1 to 3 of 3

Make a static date appear when a cell has text entered

  1. #1
    Registered User
    Join Date
    01-19-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    25

    Make a static date appear when a cell has text entered

    Hi, i am trying to find a way where is a list of cells (b3:b113) has text entered, or specific text entered, it will enter a static cell in the corresponding "d" column.

    I know of CTRL + ; but i don't really know how to get it to work as a macro, can't find a forumla that enters the static date, and i don't want to make a macro to copy + paste special the date when it happens.

    So all i should have to do is entered text in column b, then it will add a time stamp, when that text was entered, it doesn't have to update.

    Anyone have any easy VBA code to do this, or is there a forumla for this?

    Like all i need is this, but instead of the "now()" function, it will have another function that doesn't automatically update?

    =IF(ISBLANK(E5)=FALSE,NOW(),"")

    Thanks in advance guys!

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Make a static date appear when a cell has text entered

    Hi.Welcome to the forum.

    You need time stamp for this and you can also use formulas or VBA. Take a look to this.

    http://www.mcgimpsey.com/excel/timestamp.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    01-19-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: Make a static date appear when a cell has text entered

    Thanks a lot man! Working now I don't know why they don't have a static date function built in..

    Thanks again :P

+ 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. [SOLVED] Is there a quick way to make all formulas as static text?
    By BNCOXUK in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2013, 10:47 AM
  2. [SOLVED] Auto-fill Date when text is entered in another cell
    By Fett2oo5 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-07-2013, 04:12 PM
  3. When a date entered on a specific cell, automatically enter a text in other cell
    By mmccra2858 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2012, 09:57 AM
  4. Make date and time columns static after hitting Return
    By soireesmagiques in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2012, 11:17 AM
  5. Make a cell static in a formula - $A$1
    By gibbsmachine in forum Excel General
    Replies: 3
    Last Post: 08-12-2010, 11:02 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