Formating textbox's on a userform

O

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
 
T

theSquirrel

Use something like this:

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

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
 

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

Top