ExcelBanter - display $ in a userform textbox

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - display $ in a userform textbox (https://www.excelbanter.com/excel-programming/431260-display-%24-userform-textbox.html)

Sam

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

joel

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

joel

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

All times are GMT +1. The time now is 08:03 AM.