Timestamps, other than cell input?

[mpkavanagh]

I am currently using the following code to create timestamps in several columns of data.

Please Login or Register  to view this content.

This requires direct input into a cell to change. I need to have it stamp based on either of the two scenarios:

1) when a format change, such as fill colour, is made

or

2) when a form button returns a number to the cell link, this cell link is then timestamped.

In my case, I need it to timestamp when project status changes from "Green" to "Yellow" to "Red". Right now I am using the numbers 1, 2, and 3 to indicate the changes, with conditional formatting to change the cell colour, but I would rather have a list box that inputs to a cell (and the timestamp is based on the output cell).

Any ideas? I am not very good at all with VB, I pieced together the above from various help forums.

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

[mpkavanagh]

Sorry about that. Thanks for the heads up!

[shg]

I need to have it stamp based on either of the two scenarios: 1) when a format change, such as fill colour, is made, or 2) when a form button returns a number to the cell link, this cell link is then timestamped

Unlike manually changing a value or selecting a cell (among other things), neither of those generate an event.

You could use Marlett checkboxes (search the forum for many examples) with three columns that behave like radio buttons to indicate status.