I'm trying to enter email addresses via a Userform and a TextBox, and
although the data is stored in the cell, it is not in email format. If I
double click the cell and then hit a CR, it assumes the proper format. How
can I make it happen directly from the TextBox?

Tom