LinkBack URL
About LinkBacks
Hi,
I need to record time next to eg.: W3 cell,
now i'm using below formula :
=IF(W3<>"",NOW(),"")
but the NOW function keep updating time itself,
is there any VBA code or function that I can use with this formula ?
Hi,
I need to record time next to eg.: W3 cell,
now i'm using below formula :
=IF(W3<>"",NOW(),"")
but the NOW function keep updating time itself,
is there any VBA code or function that I can use with this formula ?
Just enter Ctrl-; and space and Ctrl-:
Copy the below code and do right click on sheet tab and select view code and paste it.
Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There is a sneaky way to do this with a circular reference, but before W3 is populated the value will be zero, not blank. That may not get you exactly what you want. You could add conditional formatting to hide the text when the value is zero.
This formula is put into X3:
Formula:
Please Login or Register to view this content.
Thank you guys,
I tried all 3 methods and all working just fine, just need to choose which one to use
Thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks