How to count the number of cell changed since yesterday?
 

Hi, I'm newbie with vb. Here what I would like to do:
I would like to know the number of cell changed since yesterday in a
column.
Seems simple but I don't know where to start with.
thanks

How to count the number of cell changed since yesterday?
 

You could use something similar to the below. it uses the
Worksheet_Change() event and increments B1 each time something is changed in
ColumnA

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Columns("A:A")) Is Nothing Then
Application.EnableEvents = False
Range("B1").Value = Range("B1").Value + 1
Application.EnableEvents = True
End If
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"magickarle" wrote in message
oups.com...
Hi, I'm newbie with vb. Here what I would like to do:
I would like to know the number of cell changed since yesterday in a
column.
Seems simple but I don't know where to start with.
thanks

How to count the number of cell changed since yesterday?
 

Thanks. I tried it but it gives me an execution error 424 on line 2 (If
Not Application.Intersect(Target, Columns("D:D")) Is Nothing Then
Thanks

How to count the number of cell changed since yesterday?
 

Hi
Did you put the macro in the right place?
In the vb editor, double click the appropriate sheet name listed with
your project. Paste the macro into the window that appears (the module
for that sheet).

regards
Paul

How to count the number of cell changed since yesterday?
 

Ok I've put it in sheet1 which contains the data.
The D column contains a drop-down list with 1;2;3 so the user can
choose: Called one, called twice or called 3 times

Thanks

How to count the number of cell changed since yesterday?
 

Yes. I've put it in sheet1 which contains the data.
The D column contains a drop-down list with 1;2;3 so the user can
choose: Called one, called twice or called 3 times
same issue.

Thanks

How to count the number of cell changed since yesterday?
 

Don't know what's causing that. The code is fine. can you send me the
workbook?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"magickarle" wrote in message
oups.com...
Yes. I've put it in sheet1 which contains the data.
The D column contains a drop-down list with 1;2;3 so the user can
choose: Called one, called twice or called 3 times
same issue.

Thanks

How to count the number of cell changed since yesterday?
 

Hi, I've send you an email with file attatchment. Did you find where
this error was comming from?
Thanks again for your help

How to count the number of cell changed since yesterday?
 

Hi, I don't get the error message anymore but I doesn't add 1 to the
cell.
the security is @ medium n the VBscript is in the right sheet.
Thank you

How to count the number of cell changed since yesterday?
 

I've found the problem, I got to close excell n reopen it. It seems
that it get stuck somewhere.