Several references online to this but I am missing something. "Reafidy July 2007" seemed appropriate but returns error 13 mismatch
I keep wondering if it doesn't like the format "dd:mmm:yy"
I have a text box in userform initialize displaying current date as "dd:mmm:yy" which works and displays as it should.
I am trying to transfer/copy date from txtcurrdate to spreadsheet activecell.
Private Sub cmdupd_Click() Dim FirstBlankCell As Range Set FirstBlankCell = Range("B" & Rows.Count).End(xlUp).Offset(1, 0) FirstBlankCell.Activate ' finds first blank cell in date column all ok ActiveCell.NumberFormat = "dd:mmm:yy" ActiveCell.Value = CDate(Me.txtcurrdate.Value) ' returns error ActiveCell.Offset(0, 1) = txtcurrreading.Value ' all ok End Sub
If I use activecell.value = txtcurrdate.value this returns the data but not in date format.
Any help on this I would be grateful. Thanks a lot