| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Have TextBox display a dollar value
When these TextBoxes get populated, is there any way to make them display
the result in dollars and cents? Sub DisplayPay() Dim rng Set rng = Cells(ActiveCell.Row, 1) DataInput.TextBox611.Text = rng(1, 99) ' Dispatch Pay DataInput.TextBox612.Text = rng(1, 98) 'Driveing Pay DataInput.TextBox613.Text = rng(1, 100) + rng(1, 101) ' Overtime DataInput.TextBox615.Text = rng(1, 119) 'Total Pay End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding dollar amounts in half dollar increments | Excel Worksheet Functions | |||
| display the textbox by clicking a cell | Excel Discussion (Misc queries) | |||
| How do I set $100 display as one hundrer dollar? | Setting up and Configuration of Excel | |||
| Comparing Row by Row - A-D dollar amounts to E dollar amount | Excel Worksheet Functions | |||
| Qn: Display Text in TextBox in Userform | Excel Programming | |||
Threaded Mode
