|As I read back through this thread, I'm seeing contradicting information.|
In Response # 2 you said:
"My set up is like this:
A1 -> B1
B1=time when A1 has data entered in it."
Then in Response # 4 you said:
"The function in the Time column is:
So which is it - is the data being entered in Column A so that Column B shows the time or is the data being entered in Column B with the time showing up someplace else?
Finally, the image you provided the link to shows 2 time columns, C & F.
Since the code can't "guess" what cells you are monitoring or "guess" where you want the time to appear, you need to be very specific with your requirements.
Exactly where are you entering data and exactly where do you want the time to appear?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.