automatic date and time

[hansfrimpong]

I have a Mac excel program and I want to program the work sheet templete that automatically logs in the date in column and time on colum B any time I insert and information in column C,D and E. the date and time should not change when i open that file on another day. Can anybody help?

 

[texasalynn]

Welcome to MrExcel Board....

not sure about mac but try this

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$1" Then
    Range("A1").Formula = Date
    Range("B1").Formula = Now()
    Range("A1").NumberFormat = "m/d/yyyy"
    Range("B1").NumberFormat = "h:mm"
End If
End Sub

place this code in the worksheet you want this to work in, by right clicking on that sheet tab and select view code, then paste this in

 

[hansfrimpong]

I use mac Excel 2008 and when I click the "sheet" tab I couldn't find the "view code". How do I use VBA on mac excel 2008.

 

[texasalynn]

sorry I don't know mac - you might have to do a google search. Or maybe someone here will know

 

[VoG]

There is no VBA in Mac Excel 2008 so you're stuck unless you can find a way to do this using the Mac programming language.