Adding figures in userform textbox formatted as Euro

Using VBA I can I add the values of 2 userform textboxes if they are formatted with the Pound (£) sign, BUT, I can not get it to add 2 textboxes if they are formatted with the Euro (€) sign.
txtGB1 = Format(txtGB1, "£ #,##0.00")
txtGB2 = Format(txtB2, "£ #,##0.00")

txtFrench1 = Format(txtFrench1, "€ #,##0.00")
txtFrench2 = Format(txtFrench2, "€ #,##0.00")

SO, this works

Please Login or Register  to view this content.

)

But this does not,

Please Login or Register  to view this content.

If I remove the Euro (€) sign, it adds correctly.

Thanks for looking.

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.


http://www.excelforum.com/excel-prog...d-as-euro.html
Thread Closed.