| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting Textbox, passing values to worksheet
Hello Craig, You were pretty close to solving the problem. Just move the Format statement into the TextBox's After_Update event. Use "Currency" for money formatting because it is internationally aware. Code: -------------------- Private Sub TextBox1_AfterUpdate() TextBox1.Text = Format(TextBox1.Text, "Currency") End Sub -------------------- Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=482423 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying values and formatting but not formulae to new worksheet with VBA | Excel Programming | |||
| Passing Values | Excel Programming | |||
| put worksheet values into textbox on form | Excel Programming | |||
| Excel VBA - Problem calculating and passing values to another worksheet | Excel Programming | |||
| Calling a Sub passing Textbox name | Excel Programming | |||
![Leith Ross[_226_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
