VBA Cell Value Change

  • I have officers putting a date within a cell.
    What I need the cell then to do is to convert to a NOW() value once they have hit return, enter or move to another cell.


    They input 15-Dec .. I need it to return (in the same field) 15-Dec 8:50.


    I have seen a few VBA samples for worksheet_change, but none seem to make any sense.


    HELP !! :?

  • Re: VBA Cell Value Change


    The time will be what the time is at the moment of data entry = NOW()


    I would assume there would be something in the coding to convert all cells with a format of dd/mmm to dd/mmm hh:mm


    The hh:mm component would be NOW() function.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!