| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Box
CDbl(TextBox1.value)
-- HTH Bob Phillips "jhahes" wrote in message ... Thanks all for the responses, I haven't tried your solution Harold, but Bob, your solution works great. I have one question regarding your solution though. Say I wanted to reverse the logic. I wanted to put the text box value in a sheet as a number. I know how to do this with Curreny = Ccur(TextBox1.value), how do I do this to convert this to a number format. Thanks Josh -- jhahes ------------------------------------------------------------------------ jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596 View this thread: http://www.excelforum.com/showthread...hreadid=385678 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
| Default font for pasted text in text boxes - Excel 2007 | Excel Discussion (Misc queries) | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit | Excel Programming | |||
| extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming | |||
![Bob Phillips[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
