VBA code swapping date formats??

Hi all, new here, and need some help.

I have a userform that I'm trying to autofill with the current date on activate.

Currently calling the date from another sheet, (where its set to =TODAY(), and the formatting set to dd-mmm-yy)
BUT- when the userform opens, the textbox displays the date as mm/dd/yy, which means the months and days are back to front.
I'd be happy if I could get it to show up in the dd-mmm-yy format.

Here is the code I am using:

Private Sub UserForm_Activate()

TextBox1.Value = Worksheets("Data").Cells(3, 2)
TextBox1.Value = Format(TextBox1.Value, "dd-mmm-yy")

Can anyone shed light on this, as I am stumped. In the UK, and PC set to English date format (dd/mm/yyyy)

Use the Text property of the cell.

Textbox1.Vlaue = Worksheets("Data").Cells(3,2).Text

Thank Norie, such a simple fix, but works perfectly for my needs.