| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform- Formating numbers in Textboxes
Bob , Norman,
thanks alot for your help. Ozgur "Bob Phillips" wrote: Textbox1.Text = Format(Range("A1").Value,"$#,##0.00") for example. If the range is already formatted you could use Textbox1.Text = Range("A1").Text -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ozgur Pars" wrote in message ... Hello, I am trying to find a way to format the numbers in a textbox which derives the data from a excel sheet. Nothing too fancy but I can't figure it out...any help? Thanks, Ozgur |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UserForm TextBoxes | Excel Discussion (Misc queries) | |||
| userform & textboxes | Excel Programming | |||
| userform textboxes again | Excel Programming | |||
| userform textboxes | Excel Programming | |||
| add numbers in textboxes on userform | Excel Programming | |||
![Ozgur Pars[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
