formula value input

E

eddie1

Newbie in troubles...


following VBA works with keyboard input only, but not if Target.Colum
= 3 contains a formula ....

HowTo ?

Thanks for your help


Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 2 And Target.Column = 3 Then
x = Cells(Rows.Count, "d").End(xlUp).Row + 1
Range("D" & x) = Range("C" & Target.Row)
End If
End Su
 
F

Frank Kabel

Hi
if you ned to monitor the change of a formula use the
worksheet_calculate event
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two variables for Target.Value 5
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Change_Event not responding to change made by formula. 11
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Format new rows. 2
Combine Intersect Range in If statements 5
Insert Row colors the complete Row 6
424 Object Required Error ! 11

Top