| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing text to numberformat via textbox on a form
I use textboxes on a form to enter various data to some cells in a spreadsheet. (Not a table). All values are saved as text regardless of if they are actually numbers. So I tried ths:
.... With Range("MyCell") .Value = TextBox3 .NumberFormat = "#,##0" End With .... The cell is now formatted as a number but I have to doubleclick it to appear as a number as it still looks like text and the green little mark says it has been saved as text! How do I get around this? Regards Stef |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Size in Label or Textbox in Form | Excel Discussion (Misc queries) | |||
| Form Button - Changing Text | Excel Discussion (Misc queries) | |||
| changing a text value to a number value in a textbox? | Excel Programming | |||
| textbox on form | Excel Programming | |||
| Text to Form Textbox and back | Excel Programming | |||
Threaded Mode
