clickable

I have a spreadsheet in which a lot of Text was pasted from another source. Col F contains a list of URLs, all different. The URLs are not clickable. I found some code that changed them to be clickable but I also want to code to change the screen text to "Link" for all URLs. favoriteI have a...

I want my code in VBA to set a comment within a cell with a clickable URL iside it. I can do this manually like this: 1) Click in the cell and then insert a comment as "http://www.google.com.br" 2) Right click at the comment cell, and select Show/Hide Comments to show the comment. Done, the cell...

Hi! I have the following code: Public Function urlID(InputCell As String) Dim s As String s = "https://google.com/" urlID = s & InputCell End Function But the result is just for example: "www.google.com/table" with black colour. How can I make it a clickable Hyperlink (within that...

I am working on an excel VBA program that I am trying to use clickable cells instead of command buttons. Is it possible and if so how do I make it so that if I make a column clickable the assigned macro will work only in the same row as the cell that was clicked. For example if K5 is clicked, it...

How can I stop excel from making a cell clickable if I got an email address in it? I keep opting for "remove hyperlink". But when I click back in it it becomes a hyperlink again and it becomes clickable. I tried formatting it as "general" or "text" but that doesnt work. ANy help will do.

So I'm trying to use VLOOKUP in conjunction with a hyper link, I've tried this formula =HYPERLINK(VLOOKUP(name,table,column,0),name) but when I click it, it says "cannot open the specified file"

I am trying to create a clickable survey/grading form and would like to have a red circle encompass a cells contents when selected as pictured below. Any ideas on how to make this work? I will have approximately 10 questions, each with the below graphic following it.