Automatic date & time entry using Excel VBA

Please login in order to report media.

  • Uploaded 9 months ago in the category How to programming

    Our Excel training videos on YouTube cover formulas, functions and VBA.

    Useful for beginners as well as advanced learners.

    New upload every Thursday.
    For details you can visit our website:
    If you can automate the date and time entry in an Excel worksheet using VBA then you can save time.

    Using the for loop that we learnt last time we can achieve exactly that quickly and easily.

    In fact you can fill data right upto the last cell (1048576) using the LastRow function.
    You can find the macro code here:
    Get the book Excel 2016 Power Programming with VBA:
    If you are from India you can get this book here:

  • automaticdate&timeentryexcelvba