for some reason even though the target cell is formatted as a date, when
the
textbox value is copied into the cell, the format doesn't
change the entry, as it would when manually entered).


You should do a Range("XX").Value = Textbox.Value rather than a copy/paste

--
Jim Rech
Excel MVP