Add date to useform textbox rather than sheet cell.

Hi Forum,

I have a userform with a button on to activate a calendar, this works fine for reporting to a cell in a worksheet. but how do i get it to report to a textbox in the same userform, I have tried variations of the code below. The txtbox is called TXTDateAdded. Any hints or tips for me to correct/ work out the things i'm missing would be great.

cheers Mark

Please Login or Register  to view this content.

This code below work fine and reports to cell a2

Please Login or Register  to view this content.

Mark Stock Database New REV1.xlsmHi @ protonLeah,

Your suggestion works a treat, I chaned my line based on your example to

Please Login or Register  to view this content.

and removed the line

Please Login or Register  to view this content.

. I kept the next lines as these made the calendar look how i want it

Please Login or Register  to view this content.

Included workbook in case its of use to anyone else

Oh and thanks for your assistance