Email Addresses

[Guest]

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

 

[Guest]

The reason your email addresses are not "click-able" is that you have not run
that small part of the Excel user interface that makes it "click-able"

For example, if you directly type an email address or hyperlink into a cell
and then touch ENTER, Excel analyzes the string make makes a "click-able"
link or address.

That is why it becomes click-able after you edit the cell.

If you have a long column of non-clickable addresses, say A1 thru A200:

mailto:[email protected]

then in B1 put
=HYPERLINK(A1) and copy down to make a "click-able" column.


You can instill "click-ability" from VBA as well and skip the helper column.