Hyperlink - Text Box to Macro

[Cecil]

How do I hyperlink a text box ( button ) to an existing macro?

[Richard Buttrey]

Hi

If I understand the Q, just right click, pick the Assign Macro and pick the relevant macro.

HTH

[Cecil]

See small Excel workbook attached.

First text box not hyperlinked.

Second text box is hyperlinked … to an underlying VB module.

If you right-click the second text box, you can Assign Macro ( or VB module ).

If you right-click the first text box, you cannot Assign Macro.

( chicken and an egg ) Question > How did that second text box get hyperlinked? ( this exhibit was dragged in from an already-made workbook )

What am I missing here?

Thanks.

[Leith Ross]

Hello Cecil,

Checking the macro that is called by the TextBox shows it is in your VBA project. What do you want to do or know?

Sincerely,
Leith Ross

[Cecil]

RE > Attachment.

I setup the first text box ( green ) to show that I cannot assign it to a VB module by right clicking.

I "dragged in" the second text box ( brown ) from another workbook. It is hyperlinked … to an underlying VB module.

At the risk of embarrassing myself, the question is > How did that second text box get hyperlinked?

Thanks.

[Leith Ross]

Hello Cecil,

In your case, I don't know. I use a trick to create text boxes on worksheets from members who submit workbooks. The text box contains a hyperlink to the Excel Forum post.

1. Here is what I do. Select the URL in the address bar and copy it with CTRL+C.
2. Display the Drawing tool bar on Excel.
3. Click the Rectangle
4. Paste the URL with CTRL+V
5. A TextBox is created with the hyperlink to the post.

A hyperlink can be assigned to any Shape object using VBA code.

Sincerely,
Leith Ross

[Cecil]

Yes, that is good.
Thanks Leith.
I marked the "ticket" SOLVED.
Cecil.