Right click sheet tabview codeinsert this.
now when you put t or T in cell B1 the date will appear.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" And _
UCase(Target) = "T" Then Target = date
End Sub

--
Don Guillett
SalesAid Software

"hannatrip" wrote in message
...
yes, i want it in the same cell, can you tell me how to do the
worksheet_change event macro? Im new at this :)
Thanks

"Don Guillett" wrote:


Where do you want it to POP up. If the same cell you would need a
worksheet_change event macro.

--
Don Guillett
SalesAid Software

"hannatrip" wrote in message
...
I am trying to figure out how I can type a T in a cell and todays date
will
pop up??? help please :)