Dynamic or personalized hyperlink vba excel

Hi! Thanks for reading!

I have a function that search a list of objects from a database and list them in the active worksheet.
I would like to add a function that links each object to its position in the database. This position has to be found every time with a search function. So the SubAddress of my Hyperlink function should be a function.

How can I do that?

For example I have:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=""

Where the SubAddress is a function called "search". I tried but i couldn't find the way to insert a function inside the Hyperlink function. How can I do that?

If this is not possible, how can I write a personalized Hyperlink function?


Hope someone could help me somehow!!!


Thank you very much,

Ciao from Modena, ITALY

Thank you very much karedog! I have almost solved it (I'm going to let you know :-) )

I thank you again for the advice. Very kind of you!