View Full Version : create log for entire file
fgarcia90
07-20-2012, 05:51 AM
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
07-21-2012, 11:54 PM
attach please an example
Simon Lloyd
07-22-2012, 02:55 PM
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
07-22-2012, 04:30 PM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.