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


--
Hopest
------------------------------------------------------------------------
Hopest's Profile: http://www.excelforum.com/member.php...o&userid=23765
View this thread: http://www.excelforum.com/showthread...hreadid=377022

VBA Query to Excel, Stuck.
 

Hi,

try something like

Sheets("YourSheetName").Range("a1")=YourFormName.T extbox1.Tex

--
jindo
-----------------------------------------------------------------------
jindon's Profile: http://www.excelforum.com/member.php...fo&userid=1313
View this thread: http://www.excelforum.com/showthread.php?threadid=37702

VBA Query to Excel, Stuck.
 

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
------------------------------------------------------------------------
Hopest's Profile: http://www.excelforum.com/member.php...o&userid=23765
View this thread: http://www.excelforum.com/showthread...hreadid=377022

VBA Query to Excel, Stuck.
 

Sorry , sorted it now.

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

Works fine now :rolleyes: ahh well, we all make mistakes :)

Just glad it works now! :cool:


--
Hopest
------------------------------------------------------------------------
Hopest's Profile: http://www.excelforum.com/member.php...o&userid=23765
View this thread: http://www.excelforum.com/showthread...hreadid=377022