Now funtion or today function ?

[sadiq786k]

Hello i m using scanning barcode in excel
so i m looking for small function for date & time with secs
but it should be when any data is entered in a1 a2 a3 a4 a5
so next in b1 b2 b3 b4 b5 should display date & time with secs
but it should work only if a data is entered
what is the best function to be used

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
    Application.EnableEvents = False
    With Target.Offset(, 1)
        .Value = Now
        .NumberFormat = "dd/mm/yyyy hh:mm:ss"
    End With
    Application.EnableEvents = True
End If
End Sub

 

[sadiq786k]

HELLO vog THNKS ALOT THTS BEAUTIFUL ITS WORKING , I WILL NEED SMALL HELP MORE FROM YOU , I REALLY APPRECIATE THNKS HTH PETER

 

[sadiq786k]

But isthere any same function to be used without viewcode i mean with visual basic
just normal function to be enterd in cell

 

[sadiq786k]

I mean without visual basic

 

[VoG]

If you use the formula

=IF(A1="","",NOW())

that value will change every time the worksheet calculates, so it will not be a static value.

to get a static value you can press CTRL + ; for date and CTRL + : for time, but that is not automatic.

So, you really need VBA.

 

[sadiq786k]

I m looking to programm my excel file

hello I have a file which i want to programm this file , but i dont know how to attach on this forum , plz assist me