Macroless way to post dates in another cell

  • Thread starter Thread starter HoundofCullin
  • Start date Start date
H

HoundofCullin

OK... So here's what I am trying to accomplish
Should be simple but every time I try it I get an error... so I giv
in.


I need to get it set up so that when I enter any sort of value in cel
E4 the date is automatically posted in cell I2.


So simple yet beyond my comprehension
 
right click on the sheet tab>view code>insert this
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$E$4" Then range("e12")=date
End Sub
 
Don

doesn't that constitute a macro ? Can't see another way but maybe not what
the OP wanted.

Regards

Trevor


Don Guillett said:
right click on the sheet tab>view code>insert this
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$E$4" Then range("e12")=date
End Sub
Click to expand...
 
OP said
"so I give in."
so I gave it to him

--
Don Guillett
SalesAid Software
(e-mail address removed)
Trevor Shuttleworth said:
Don

doesn't that constitute a macro ? Can't see another way but maybe not what
the OP wanted.

Regards

Trevor
Click to expand...
 
One way

first turn on iteration under tools>options>calculation (check the box),
in I2 put this formula

=IF(E4="","",IF(I2="",TODAY(),I2))

note that if you want to keep entering values in E4 it will stay fixed
unless you first delete
what's in E4, then enter a new value again, then it will update
 
Back
Top