Add Current Date to Cell Via Macro Code

  • Hi Everyone ..


    I am using the code below to auto input a date once another cell has had a value entered into it.
    However .. the code seems to display the date WITH the time.
    I have formatted the cells, but if you place your cursor in the cell, the value is the date & the time.


    How do I populate cell 'C' with the date only in the format I have specified WITHOUT the time when cell 'B' has a value entered.



    Thanks
    Tayler


    Tayler [the blue fox] :thanx:

  • Re: Date And Time Formatting


    hi [the blue fox],


    try changing the

    Code
    1. .Value = Now


    to

    Code
    1. .Value = Date


    hth

    Cheers
    ___________
    Xlite :sheep:
    [st]All you need to learn VBA is an internet connection and Ozgrid.com[/st]