Formating textbox's on a userform

[Oggy]

Hi

I have created a userform with several textbox's on. They pull in
infomaton form a cell on a spreadsheet and i then can edit them if i
wish to do so.

How can i format the text box's to show 2 decimal placings and
currency.

Many thanks in advance

Regards

Oggy

 

[theSquirrel]

Use something like this:

me.textbox1.value = format(me.textbox1.value, "$###,##0.00")

 

[Oggy]

Thanks,

this is what i am looking for, but when i enter a number eg 2.72 it
rounds up to 3.

Do you have any suggestions.

Thanks again

Oggy