(Solved) – Insert a Hypertext link in an Excel textbox

  • by
(solved)-–-insert-a-hypertext-link-in-an-excel-textbox

I have a sheet with a textbox, created with VBA :

With Worksheets(1)
  .Shapes.AddTextbox(msoTextOrientationHorizontal, 0, 0, 100, 100).TextFrame.Characters.Text = _
      "Some text here" & LinkHere & "Maybe more text here"

I would like to insert a link in the text of the textbox.
The link i would precisely add is a "mailto:" link.

Leave a Reply

Your email address will not be published. Required fields are marked *