| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Query to Excel, Stuck.
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!  -- Hopest ------------------------------------------------------------------------ Hopest's Profile: http://www.excelforum.com/member.php...o&userid=23765 View this thread: http://www.excelforum.com/showthread...hreadid=377022 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Excel Spreasheet stuck | Excel Discussion (Misc queries) | |||
| Stuck With Excel Problem | Excel Discussion (Misc queries) | |||
| AutoCalc in Excel is stuck! | Excel Discussion (Misc queries) | |||
| Excel with game is stuck in a loop | Excel Discussion (Misc queries) | |||
| Excel Concatenate - Please help, really stuck | Excel Discussion (Misc queries) | |||
Linear Mode
