create log for entire file

[fgarcia90]

Can I create a simple code :( to tracks changes of a userform "form_principal" with several things in multiple pages to go in a worksheet of that file named "logreg".
If it would be possible to go with user, date+time stamp and before change and after change it would be great...


thanks in avdanced

[patel]

attach please an example

[Simon Lloyd]

You would be better off having an xlveryhidden worksheet where you deliver the contents of the userform on initialize and then add the environ("username") and DATE and TIME

[fgarcia90]

patel here is a base of my work.
Simon Lloyd, I've search the webforum's to create a log of any change in each field, but I want to record if for example:

in a Combobox
user A changed to 3
user C changed to 75
.
.
.
adding environ("username") and date + time

and yes, it could be in veryhidden,

but my question is: as I have so many fields (I just attached a small part) :)
is there a universal way to say in this workbook (and includding userforms) log every change made to that veryhidden sheet?
:dunno