Add screentip on a Hyperlink Function

[pipoliveira]

Dear All,

Trust you're all well.

I am adding a formula into a table column when user type only the YouTube video ID in one cell (on this case, cell M12).

The cell N12 have the following formula and will only show up if value in cell M12 is <> than "":

Please Login or Register  to view this content.

In the Hyperlink function, we only have the following: HYPERLINK(link_location, [friendly_name])

Is there anyway to add a screentip name based on another cell value?

I see this option only available if adding an Hyperlink manually or through VBA code.

Can we do it in a formula?

Your assistance on this matter will be highly appreciated.

Best regards,
Filipe

[shukla.ankur281190]

Can you please explain it clearly? I don't understand the things

[pipoliveira]

Hi Shukla,

Thanks for the prompt reply.

In short, is there a way to insert a screentip on a Hyperlink function?

The screentip is the message or text when users hoover the mouse through an Hyperlink.

Many thanks in advance and kind regards,
Filipe

[dominicb]

Good afternoon pipoliveira

Through a worksheet function? No.

You could fudge something using VBA. As a working example, the code below would put the text "Open Video" in cell A1, the hyperlink address would be in cell A2 and the screentip would show the contents of A2, but it could just as easily be any other cell.

Ideally, you would want this as an event procedure, so it fires automatically on the Worksheet_SelectionChange.

Please Login or Register  to view this content.

Is this something you could work with? If not, you're pretty much out of options I'm afraid.

HTH

DominicB

[pipoliveira]

Thanks a million Dominic,

I thought so since the Hyperlink function can only allow to type the link address and the friendly name.

May I please ask how to twist the your code to a range?

The thing is, this videos are updated into a sort of table and using your example, the range will be "A1:A100".

How I change your code when users start updating the "table" with more videos? You code will only add an Hyperlink to Cell "A1".

I need to add Hyperlinks only to the rows that have links updated, the ones with no links, should be kept "blank".

Many thanks in advance and kind regards,
Filipe

[dominicb]

Hi pipoliveira

Can you post your workbook, or at least a small portion of it - I don't need to see all 100+ rows, just enough that I am not working blind.
Feel free to change links and anonymise any data you may feel is sensitive - I just need to understand the structure.

HTH

DominicB

[pipoliveira]

Hi Dominic,

Trust you're well.

Please see sample file attached.

Columns "C" and "G" have Hyperlinks and the only part of the table that needs to be updated manually are from column "D" to "F".

In column "I" is how I want it to be. If you hoover the mouse through the link, you'll see the screentip.

On this example, everytime a user updates a link in column "F", it should update column "G".

Let me know if you need further clarification.

Best regards,
Filipe

[dominicb]

Hi pipoliveira

See if this file does what you expect.
You need to fill in columns C, D, E and F and the click the button. This should then generate hyperlinks for all items you have listed on that page.

HTH

DominicB

[pipoliveira]

Hi Dominic,

Thanks a million for the code.

Instead of a Command Button, I've added the code to the Worksheet_SelectionChange.

The only thing I've changed, was the LastRow Dimension from "C" to "F", meaning, if the users does not upload the short link, it will not add an Hyperlink.

Thanks a million for your code, it works as I wanted.

Really appreciated for your time.

Best regards,
Filipe