Formating textbox's on a userform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Oggy - 23 Jan 2007 20:08 GMT

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

Reply to this Message

theSquirrel - 23 Jan 2007 20:12 GMT

Use something like this:

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

> Hi
>
[quoted text clipped - 10 lines]
>
> Oggy

Reply to this Message

Oggy - 23 Jan 2007 21:01 GMT

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

> Hi
>
[quoted text clipped - 10 lines]
>
> Oggy

Reply to this Message