Hi Folks,
I am posting with regards t userforms and inserting data into worksheets.
Inserts the email address that my user puts into his/her form into my worksheet beautifully however the information inserted does not auto hyperlink as an email link or url.
How can I or what am I missing to make the inserted information a live email when it is inserted?
I have been trying to work this out for days so any assistance would be greatly appreciated Folks
Cheers
Kpm51
I am posting with regards t userforms and inserting data into worksheets.
Code:
Cells(2,9)= AccEmailAddress.Text
Inserts the email address that my user puts into his/her form into my worksheet beautifully however the information inserted does not auto hyperlink as an email link or url.
How can I or what am I missing to make the inserted information a live email when it is inserted?
I have been trying to work this out for days so any assistance would be greatly appreciated Folks
Cheers
Kpm51