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.