Problem formating text boxes

Hi,

I'm facing a very weird problem is one of my userforms. I have a lot of text boxes reading values from the worksheets behind. This is an example of the code I'm using to format the text boxes:

Please Login or Register  to view this content.

Similar pieces of code like this are repeated in a dozen other text boxes. The funny thing is that, when I open the workbook application, some of my text boxes will be properly formatted, others won't. I have to go to the System\Control Panel\Regional Settings\Formats\Additional Settings\Reset to restore the default values of my local settings (I live in Europe, therefore I want my currency to be €).

Once I do this, all text boxes behave properly, but if I don't some text boxes will present the correct values but with wrong formatting.

What am I missing here?

Thanks!

Could we see the workbook?

BSB

The problem appears to be solved!

I changed my code to:

Please Login or Register  to view this content.

So, I'm no longer formatting the text boxes and Excel is displaying the proper formatting coming from the cells. So far, it appears to work like a charm.

Thanks!