Format Label.Caption or Textbox data

  • Thread starter Thread starter RobC
  • Start date Start date
R

RobC

I preload labels.captions from worksheets as the form loads. Some are
Dollar amounts and would like to present them with commas and $. the $ is
easy to add but the commas are tough without a format type. Is there any
way to set the format on a label.caption or textbox as you do in cells,
i.e., Currency?
Thanks, Rob
 
Label1.Caption = Format(12345.78,"$#.##0.00")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
That worked PERFECT. Couldn't find that info anywhere. Thanks for the
help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Textbox Formatting Trouble 3
.find does not find if .NumberFormat = "#,##0.00" 2
Userform Text box Format to Currency 2
User Form Text Box 2
Need Macro... 8
Accounting Format Text in a Textbox 4
VBA currency or percent format object 1
Calendar Userform Problems 2

Back
Top