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????