Edit cells with form - Number format

[Un-Do Re-Do]

With this form, cells can be edited using a userform. Buttons exist so that special characters can be added such as Greek letters.
It works for strings but not for numbers.
I've tried to format numbers as Text using "cell.NumberFormat = "@"" but no success.
Can any one help?

Please Login or Register  to view this content.

[Logit]

.
If you type "123" into the form field, then click on one of the command buttons, what is supposed to appear in the cell ?

I do not receive any errors here.

[Un-Do Re-Do]

With this code, the typing is not taken into account. Transfer is only supposed to be with the command buttons. My guess is that the issue is because the number is not a string.

[Un-Do Re-Do]

This seemed to have worked if anyone's interested.
In the FormCreation module, add as shown.

Please Login or Register  to view this content.