| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display $ in a userform textbox
Hi All, I have a userform in excel that accepts amount values.. My Question is:
Is there a way I can display a '$' Sign in text box accepting amount values? Thanks in Advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
display $ in a userform textbox
format the data
amount = 10.23 textbox1.value = format(amount,'"$") "sam" wrote: Hi All, I have a userform in excel that accepts amount values.. My Question is: Is there a way I can display a '$' Sign in text box accepting amount values? Thanks in Advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
display $ in a userform textbox
Sould of been
amount = 10.23 texbox1.value = Format(amount, "$#.00") "sam" wrote: Hi All, I have a userform in excel that accepts amount values.. My Question is: Is there a way I can display a '$' Sign in text box accepting amount values? Thanks in Advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform Textbox to Worksheet Textbox | Excel Programming | |||
| fill userform textbox from userform listbox clik event | Excel Programming | |||
| How to feed a userform a variable to display in a textbox? | Excel Programming | |||
| Qn: Display Text in TextBox in Userform | Excel Programming | |||
| UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Linear Mode
