Textbox changing date value to text

Good Afternoon,

Im a bit of a novice with vba so am after a bit of help if possible.

I have the following code:-

ActiveCell.Offset(0, 4) = Textbox1.Value

I have a calendar set up that filters the date into the userform textbox. When i click a button to save all the data into a worksheet it is formatting it to text.

I have tried cdate but because i am sharing the worksheet it is giving me an error.

any help will be appreciated