I have a completed code 1 to 5 which tracks the progress of a project.
I have 5 text boxes each called, date of stage 1, stage 2 etc etc
so each time the code is changed the text box is inputted with the date, (so we can keep track of the time a project takes etc)
is there a way to e.g.
user changes code from 2 to 3.
the date of stage 3 box then becomes stamped with that date. I can use the =today() , but the date obviously changes! and i need I suppose an if completed code=3 populate "date of stage 3 txtbox" type coding of some sort.
any tips gratefully received.
ta
John
I have 5 text boxes each called, date of stage 1, stage 2 etc etc
so each time the code is changed the text box is inputted with the date, (so we can keep track of the time a project takes etc)
is there a way to e.g.
user changes code from 2 to 3.
the date of stage 3 box then becomes stamped with that date. I can use the =today() , but the date obviously changes! and i need I suppose an if completed code=3 populate "date of stage 3 txtbox" type coding of some sort.
any tips gratefully received.
ta
John
