VBA Query to Excel, Stuck.

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

Hi,

try something like

Sheets("YourSheetName").Range("a1")=YourFormName.Textbox1.Text

Yea that works but it puts the value of the textbox in the cell as Text not a Number.

Reason I need it as a number is because I use the SUMIF formula and it will not read the value of the cell if it is set as Text.

Sorry , sorted it now.

I forgot to put .value at the end of the textbox.

Works fine now ahh well, we all make mistakes

Just glad it works now!