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(txtGB2, "£ #,##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.

Use the Chr function

Please Login or Register  to view this content.

Thank you for a quick reply.

This did indeed format the textbox with the Euro symbol.

I failed to mention that I have a check on data entry to ensure that only a number is entered.

Please Login or Register  to view this content.

so this is now my stumbling block, it dosen't see the Chr(128) as a numberic but it does see the £ as numeric.

Tina

I tried the code you suggested, but got stuck in a loop and ended up with many many Euro symbols.

I can't see where I could do the validation before adding the Chr as I want to check that only a number is entered into the text box, thats why I have a "change" event.

Tina