Formating textbox's on a userform
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 |
Formating textbox's on a userform
Use something like this:
me.textbox1.value = format(me.textbox1.value, "$###,##0.00") Oggy wrote: 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 |
Formating textbox's on a userform
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 Oggy wrote: 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 |
All times are GMT +1. The time now is 10:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com