Results 1 to 5 of 5

VBA Macro To Clear Cell When Specific Text Is Entered

Threaded View

paulm99 VBA Macro To Clear Cell When... 01-13-2014, 05:34 PM
Marc L Try this ! 01-13-2014, 10:40 PM
stnkynts Re: VBA Macro To Clear Cell... 01-13-2014, 11:01 PM
paulm99 Re: VBA Macro To Clear Cell... 01-14-2014, 06:45 PM
paulm99 Re: VBA Macro To Clear Cell... 01-14-2014, 06:52 PM
  1. #1
    Registered User
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    8

    VBA Macro To Clear Cell When Specific Text Is Entered

    I currently use the following code to clear certain cells at a time interval of 2 seconds:


    Sub CC()
       Sheet1.Range("O9,O11,O13,L10,L12,L14").ClearContents
       Application.OnTime Now + TimeValue("00:00:02"), "CC"
    End Sub
    However I would like to clear the cell whenever the cell contains a specific word, ie Total. The cell is updated automatically from another source.

    Is there an easy way to change this?

    Many Thanks For Any Help!

    Paul
    Last edited by JBeaucaire; 01-13-2014 at 07:10 PM. Reason: Added missing CODE tags, please read and follow the Forum Rules, link in the menu bar above. Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 11-26-2012, 05:21 AM
  2. Display msgbox when specific text entered in specific range
    By Ali_Riza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2012, 08:05 AM
  3. Macro to Save As and clear cells data was entered
    By lfmemp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 12:14 AM
  4. 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
  5. Macro that will clear contents of cell based on format of text in adjacent cell
    By judasdac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2012, 01:56 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