Can hyperlinks based on Shape.TextFrame2.TextRange.Text be updated when the text changes?

I have code that gives a hyperlink to shapes (that represent a data flow process listed in another sheet in the workbook) based on the text in the shapes and shape name. But if I update the text in the shape from "ABC" to "XYZ", the hyperlink still takes me to ABC and not to the new location. Is there a way to get the hyperlinks to update automatically when you change the text in the shape and then click on the shape? My current code is below:

Please Login or Register  to view this content.

Moderators note: code tags added for you - this time

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here