Hello all,
I want the time (maybe time & date) to automatically fill in a cell when info is put into another cell. I have used an IF formula with NOW() but it changes whenever any cell is changed and I need it not to change after its inputted.
Thanks
Hi,
In it's most basic form this is how to achieve this using VBA:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$A$1" Then Exit Sub Target.Offset(0, 1) = Now End Sub
Right click on the sheet tab, select View Code and paste the above onto the code page that appears.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks