Code Reuse - Logging Actions When a Cell Changes -2

**webbug08** · 05-02-2009, 06:28 AM

Hi all,

With reference of thread
http://www.excelforum.com/excel-prog...ml#post2085981

I have made an class and created a file to log when user change value or insert formula in a sheet get recorded in a file C:\Logme.csv

The problem is it is recording the value and formula at random i.e in some instances it records the value and in some instances it is not recording the value and formula in logme.csv . I am unable to figure out why this is happening?

can some1 help in this regard.

Govind

**karan** · 05-02-2009, 02:22 PM

Hi Govind,

The file looks proper to me. However, at one place in the Auto_Open module, I have written the code:

Please Login or Register  to view this content.

I changed the path of the log file to my comp's local path and tried running your macro. It is running perfectly and without any issues.

I have added a couple of message boxes to indicate Enabling and Disabling of the function.

In case there is an error in running the function and you get the Debug/End window, the Global/Public values are lost. I guess something like this must have happened in your case.

Regards,
Karan

**webbug08** · 05-02-2009, 04:12 PM

Thanks a ton Karan

**VBA Noob** · 05-02-2009, 04:35 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save