Worksheet_Change Question

[LearnMeExcel]

Hi
when i use this event
Private Sub Worksheet_Change(ByVal Target As Range)
i want to check the Active cell
for example :
i am in CEll R15
i want to check if the cell P15 = "PP1"
if it is ok take the value which i will entered in Cell R15 and then copy it to Sheets("Truck")
first problem when i enter the value to R15 then press enter the active cell will be R16

 

[baitmaster]

yes, but TARGET refers to R15, i.e. it is the cell (or range of cells) that you are changing

 

[Sektor]

[COLOR="Blue"]Private[/COLOR] [COLOR="Blue"]Sub[/COLOR] Worksheet_Change([COLOR="Blue"]ByVal[/COLOR] Target [COLOR="Blue"]As[/COLOR] Range)
    [COLOR="Blue"]If[/COLOR] Range("P15") = Range("PP1") [COLOR="Blue"]Then[/COLOR]
        Target.Copy Sheets("Truck").Range("A1")
    [COLOR="Blue"]End[/COLOR] [COLOR="Blue"]If[/COLOR]
[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]

 

[LearnMeExcel]

yes, but TARGET refers to R15, i.e. it is the cell (or range of cells) that you are changing

do you mean to use if target.value Not activeCell.value

sektor
i need to check many cells not just R15
R15
R16
R17
.
.
.
.

 

[baitmaster]

target is the range that you are changing. It might consist of one cell or a number of cells

activecell is the single cell that is currently active, which usually changes after you enter something into a sheet

so you can use target.copy in the same way you might consider activecell.copy for example

or you could look at every cell in your range, by using

dim cl as range
for each cl in target
msgbox cl.value & vbcr & cl.address' for example, or another action
next cl

I often use colour as a way of understanding which ranges are being used in my code
target.interior.colorindex = 6