LinkBack URL
About LinkBacks
I want to use a function that displays the current date if the status column cell changes. For example, if status changes to "approved" then date = current. But I want the date to change no matter what the user selects in the Status column.
I want to use a function that displays the current date if the status column cell changes. For example, if status changes to "approved" then date = current. But I want the date to change no matter what the user selects in the Status column.
if you want the date to change "no matter what" then use the function =today()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I want the date to change to the current date if the contents of another cell changes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks