Results 1 to 12 of 12

Clear Contents, Independent Instances; Separate Worksheet VBA

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2015
    Location
    TX, USA
    MS-Off Ver
    2013
    Posts
    69

    Clear Contents, Independent Instances; Separate Worksheet VBA

    It's me again...

    So to explain I have a series of 15 sheets.
    Each sheet provides it's own references, dynamic ranges and so on.
    I have provided an "Options" Tab. But, this by no means where all selections and fields are filled in.
    I have a number of options on the Options tab, that I need to change corresponding cell in Sheet1 to blank,
    if the referring cell in the Options tab changes.

    WORKSHEET15 (Options Tab)
    Private Sub Worksheet_Change(ByVal Target As Range)
        If Target.Address(0, 0) = "I16" Then
           Worksheets("Character Sheet").Range("C5").ClearContents
        End If
            If Target.Address(0, 0) = "I17" Then
           Worksheets("Character Sheet").Range("C7").ClearContents
        End If
    End Sub
    However, I also need dependent dropdown cells in Sheet1 to clear when their source is changed in Sheet1.

    Private Sub Worksheet_Change(ByVal Target As Range)
        If Target.Address(0, 0) = "E1" Then Range("E2").ClearContents
        If Target.Address(0, 0) = "K7" Then Range("L7").ClearContents
        If Target.Address(0, 0) = "K8" Then Range("L8").ClearContents
        End Sub
    While I am learning what all of this means; in no way do I claim to understand the breakdown or code as a whole. I have only recently started tinkering with VBA, whereas I am generally good enough with functions and data validation to cobble things together.

    As always, any help is greatly appreciated.
    Last edited by Entregan; 10-03-2018 at 02:56 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Clear Contents, Independent Instances; Same Worksheet VBA
    By Entregan in forum Excel General
    Replies: 2
    Last Post: 10-01-2018, 07:35 PM
  2. Need VBA to Clear Contents of All Instances for Data Validation
    By SStreckfuss in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2018, 01:49 PM
  3. [SOLVED] Clear Contents in an another worksheet
    By Keibri in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-26-2015, 02:21 AM
  4. [SOLVED] Clear Cell Contents on Worksheet Change
    By nickhunt in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-22-2015, 03:18 AM
  5. Independent SheetX.cells.clear command per sheet
    By paradoxofthecat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2014, 04:43 AM
  6. [SOLVED] Clear Contents in Multiple WorkSheet
    By Allansdc in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 12-18-2013, 10:32 AM
  7. Clear Contents of Cells On Another Worksheet
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2012, 05:27 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