+ Reply to Thread
Results 1 to 3 of 3

Enter additional text into cell containing data

  1. #1
    Registered User
    Join Date
    04-28-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Enter additional text into cell containing data

    Hi, I was hoping to get some help. I need a macro for excel that will do the following:
    1. change the text in the selected cell to black, and then
    2. place a line in the cell at the end of the current text (Alt+enter) and then
    3. change the text color to red and write UPDATE and insert the date, and then
    4. leave the cell selected and open to allow immediate typing.

    For example:
    In any selected cell
    Blah blah blah

    After the macro
    (BLACK) Blah blah blah
    (RED)UPDATE DATE "text"

    Then if the macro was used in that cell again it would result in
    (BLACK) Blah blah blah
    (BLACK)UPDATE DATE (old) "text"
    (RED)UPDATE DATE (new) "text"

    Thanks for any help that you can provide, this is chewing up a huge amount of my time.

  2. #2
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: Enter additional text into cell containing data

    Hi jake
    try this as a bare bones solution.
    I have just used Range("A3") on the ActiveSheet to test so you will need to code-up the sheet/cell to be updated.
    Also doesn't check for empty cell etc.etc.
    Should get you going though.

    Please Login or Register  to view this content.
    Last edited by barryleajo; 06-04-2011 at 06:11 PM. Reason: update with an alternative suggestion

  3. #3
    Registered User
    Join Date
    04-28-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Enter additional text into cell containing data

    Thanks Barry
    I'll try it now and see how it goes.

+ 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