Help with Code: Timestamp a column under two criteria

[ironfelix717]

Hi,

I currently have some code that timestamps a column if the value of the target cell becomes > 0. I attempted to further the code where if a different cell is greater equal a value, the timestamp would also occur.
CODE:

Please Login or Register  to view this content.

It does not work. The above code is also confusing, as it uses Integers to represent columns. I would prefer if I could just establish the column's letter reference to alter my code.

In essence, what I am trying to achieve is...

If a cell in column S becomes greater than 0, then timestamp (i.e. 'Now()') in column X
If a cell in column H equals the word "DOWNTIME" then time stamp in column X
If a cell in Column B has text, then stamp the DATE in xx/xx/xxxx format in column D



Any help would be appreciated by the VBA gurus!

Thank you

[davesexcel]

Can you explain how these cells are changing?

[ironfelix717]

Can you explain how these cells are changing?

Hi davesexcel,

In more detail:

There are many rows of data (blank). Each row has different fields to be entered by the user. When column S has a number in it entered by the user which is greater than 0, i would like column X to timestamp in the corresponding row with the Now() function.

Likewise, if a cell in column H contains the word "DOWNTIME", which is entered by the user, then in the corresponding row, under column X i would also like a timestamp.

Lastly, if Column B changes (i.e. has text in it - originally blank, user enters words) the current date is stamped in column D.


Thanks

[davesexcel]

This should work.

Please Login or Register  to view this content.

[kev_]

I would prefer if I could just establish the column's letter reference to alter my code.

- function added to allow you to use column letter

Place code in sheet module:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

How function works:
- if target cell is A7
- its address is $A$7
- this address is split each time $ is encountered
- it is split into its 2 components "A" and "7"
- addr(1) is "A"
- addr(2) is "7"