LinkBack URL
About LinkBacks
When I display any text into any cell of column A I would like for the current date to automaticly be displayed in the corrisponding cell in column B. Any suggestions? Thanks.
When I display any text into any cell of column A I would like for the current date to automaticly be displayed in the corrisponding cell in column B. Any suggestions? Thanks.
'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location
'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Past macro into the Worksheet Module displayed
This code allows for multiple changes at the same time, Like when you paste into the sheet
It palces now date & time in column B - Format column B to display as required
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Thanks Mudracker. It worked like a champ. For others, when you save the document it needs to be saved as a macro enabled workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks