ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA - inserting text as link (email to) (https://www.excelbanter.com/excel-programming/297679-vba-inserting-text-link-email.html)

ajliaks[_20_]

VBA - inserting text as link (email to)
 
Hi,

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



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

Thanks

--
Message posted from
http://www.ExcelForum.com


Bob Phillips[_6_]

VBA - inserting text as link (email to)
 
Go to InsertHyperlink 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)

"ajliaks " wrote in message
...
Hi,

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



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

Thanks.


---
Message posted from
http://www.ExcelForum.com/





All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com