VBA Query to Excel, Stuck.

[Hopest]

Hi,

How do you copy the value from a TxtBox from a Userform to an Excel Cell as a number not text?

So Txtbox value = 5

How do you make it so that Cell A1 = 5 but as a number not text.

Thanks