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

 

[jindon]

Hi,

try something like

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

 

[Hopest]

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.

 

[Hopest]

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!