+ Reply to Thread
Results 1 to 3 of 3

Private sub to whenever cell change the other cell will be cleared content

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    378

    Private sub to whenever cell change the other cell will be cleared content

    Hello,

    I'm looking for a private sub that when Cell B2 change value or text, cel C2 will be clear content. Appreciate if you can help.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Private sub to whenever cell change the other cell will be cleared content

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("B2")) Is Nothing Then
        Range("C2").ClearContents
    End If
    End Sub

  3. #3
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    378

    Re: Private sub to whenever cell change the other cell will be cleared content

    Thanks very much

+ 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] Private sub won't change cell value like it better before I burn it to the ground!
    By rybussell in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-29-2013, 03:25 PM
  2. [SOLVED] Add Date Stamp when cell if modified and delete if content is cleared
    By nicholas.robinson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-31-2012, 01:48 PM
  3. Change cell content based from another cell's content
    By RochesterColonial in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2010, 03:43 PM
  4. Message if Cell Content Cleared
    By Ryusui in forum Excel General
    Replies: 7
    Last Post: 11-03-2009, 06:46 PM
  5. Cell Change Private Sub
    By bakes1 in forum Excel General
    Replies: 5
    Last Post: 01-31-2007, 12:10 PM

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