user form input

[Jason Logue]

Is it possible to have the data entered into a userform
automatically be formatted according to a currency
format? I am creating a large table in a userform with
several textboxes. Each textbox will populate a cell that
will then change the final row or column according to a
formula.

I am looking for something similar to how you can control
the input in a formfield.

TIA,
Jason

 

[Doug Robbins - Word MVP]

Hi Jason,

Apply the Format function

ActiveDocument.Formfields("bmname").Result = Format(TextBox, "$#,##0.00")

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a consulting basis.

Hope this helps
Doug Robbins - Word MVP