I have a UserForm with two TextBoxes (txtReportedTimeHours & txtReportedTimeMins) which are written to a single column (Reported Time) when I Save the UserForm using ...
... where the m in Cells(m + 1, 10) is the next row - THIS ALL WORKS FINE
I now want to read Reported Time back into the TextBoxes ie separating out HH:MM into HH & MM but can't work out how to read left of : into txtReportedTimeHours and righ of : into txtReportedTimeMins ...
Can anyone help please?
Thanks ...
VBA Code:
Cells(m + 1),10.value = txtReportedTimeHours & ":" & txtReportedTimeMins
... where the m in Cells(m + 1, 10) is the next row - THIS ALL WORKS FINE
I now want to read Reported Time back into the TextBoxes ie separating out HH:MM into HH & MM but can't work out how to read left of : into txtReportedTimeHours and righ of : into txtReportedTimeMins ...
Can anyone help please?
Thanks ...