I cannot see an easy way to do this.

I am not an expert on userforms. However, I think what you may need to do is
not link the textbox on the userform to the cell, but put code in the useform
to cast the value of the textbox as a numeric  value (Clong for example) and
then set the cell in the worksheet to that value.