christoday
02-04-2007, 03:05 PM
I've created a userfrom to retrieve data from a spreadsheet and save it back as appropriate. Data from specific cells is poulated into the corresponding text box. I have received some excellent assistance from Charlize on the search and save functions.
The problem I've been trying to solve for the last few days is a date formatting anomaly. Where the date in the cell is in the format dd/mm/yyyy, the form retreives this and reformats it to mm/dd/yyyy.
I've received some assistance with this but I'm finding it very hard to code the solution into the form. Any ideas/help?
The majority of cells are dates but one example in my form is TxtLetter and this corresponds to (0, 6)
I've attached, thanks.
The problem I've been trying to solve for the last few days is a date formatting anomaly. Where the date in the cell is in the format dd/mm/yyyy, the form retreives this and reformats it to mm/dd/yyyy.
I've received some assistance with this but I'm finding it very hard to code the solution into the form. Any ideas/help?
The majority of cells are dates but one example in my form is TxtLetter and this corresponds to (0, 6)
I've attached, thanks.