VBA - inserting text as link (email to)

[ajliaks]

Hi,

If I have a text like this, in a userform,

[email protected]

How can I make it a link (mail to). with subject: "AAAAAA"

Thanks

 

[Bob Phillips]

Go to Insert>Hyperlink and modify the Text to Display

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)