create a macro which monitors the cell "c1" to be changed to "a" Closed

Question

Hello, 
I hope someone can assist with this
In my workbook; I have two worksheets labeled "log" and "master"
I want to create a macro which monitors the cell "c1" to be changed to "a" or "A" in "log" worksheet and creates a new worksheet copying the contents of "master" 
Any help in matter will be greatly appreciated 
Regards
Fawaz



Configuration: iPad / Safari 9.0

ac3mark · Answer

Here is a simple one:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim KeyCells As Range

Set KeyCells = Range("A1")
    
    If Not Application.Intersect(KeyCells, Range(Target.Address)) _
           Is Nothing Then
       
       'do your stuff here!
       
    End If
End Sub
  
 
It's kind of fun to do the impossible! -Walter Elias Disney

Create a macro which monitors the cell "c1" to be changed to "a"

1 response

Similar discussions

Subscribe To Our Newsletter!