Datevalue Problems

  • Hi
    I am wondering if anyone can help. I am trying to take a date input on a userform and place it into cells on a worksheet to then use that date trigger input into a data chart.
    To my cost I found that the excel work sheet did not recognise the data as a ‘date’ but as text and so would not input the data into the chart.
    On reading various sources on the web I found the ‘datevalue’ formula and so set it up in the spreadsheet to input the raw text data into one row of cells and then use the above in another row to reference the first cells to change it into the date code. Fantastic sorted until today, the system was working a treat yesterday but for some reason today it’s stopped working. Anyone, any ideas????


    Best regards


    zeninc

  • Re: Datevalue Problems


    If you could attach an example I'm sure we could figure it out for you. Also, you could try to avoid using DateValue by ensuring the value you write to the cell is a valid date that Excel understands. for example, something like:

    Code
    1. range("A1").value = cdate(textbox1.text)


    Also, welcome to the forum!
    Ger

    Check out our new reputation system. Click on the Like button under the post!
    _______________________________________________

    [SIZE=8px]There are 10 types of people in the world. Those that understand Binary and those that dont.


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...


    The BEST Lookup function of all time


    Dynamic Named Ranges are your bestest friend[/SIZE]
    _______________________________________________