hyperlink

  1. H

    Format cell to be a hyperlink

    I have a cell which is referencing a cell in another worksheet, which contains an email address. The source cell formats properly as a hyperlink, but the destination (?) cell does not format as a hyperlink. Is it poissible to have the destination cell be formatted as a hyperlink?
  2. N

    In-workbook hyperlink and vlookup

    Hello and thank you in advance for any help. I'm looking to have VLOOKUP return a hyperlink, but one which is a reference within the workbook, rather than a URL. Can't find a format for writing the hyperlink to begin with that Vlookup can then return as working. Explanation of the below...
  3. R

    Excel Follow Hyperlinks with VBA problem

    Hello guys, I'm new to this forum and I wanted to say that English is not my native language, so if I make some mistakes, please forgive me. I'm trying to create a fitness related Excel "software" but I have some problems with hyperlinks. In the workbook I have one main tab (named "Intro")...
  4. K

    Weird bug in PowerQuery hyperlink generation?

    I have a sheet that generates hyperlinks automatically based on other cell values using a custom column. It has been working fine until now, but I just started seeing some weird bugs in it. My custom column fomula is as follows: "'=HYPERLINK(""" & "URL<url>/files/J01009/" & [Account_Number] &...
  5. T

    Hyperlink to email

    Hi all, I am trying to make life a bit easier by hyperlinking data from an excel sheet to an email whereby you don't really need to copy anything into it. I managed the below formula however it seems like if I go over a certain number of characters within this formula, the result ends up being...
  6. mole999

    hyper links to Chrome from Cell

    I have been using =HYPERLINK("http://gridreferencefinder.com/","GRF" ) for a while work has suddenly started to use from the desktop "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" https://servicedesk.x anyone do that? and replicate it as a cell hyperlink, I've tinkered and each...
  7. K

    Hyperlink & Vlookup formula

    hi, i have 1 workbook with 2 tabs - on Sheet 1 i need to hyperlink the column COLOR to Sheet 2 with vlookup function. i've tried this but doesn't work. =HYPERLINK(VLOOKUP(B2,'SHEET 2'!A1:B3,2,0) please help me with this. i will need to key in the formula in Sheet 1 B2, and when click on B2...
  8. V

    Creating a conditional hyperlink...

    I'm an Excel novice, so I appreciate any help anyone can provide on this. Here's the situation: 1. I have a cell on a sheet that will be either remain empty or be populated with text, depending upon the value of another cell. Let's say the text that'll appear is "Opp" 2. If the text "Opp"...
  9. A

    Hyperlink retured through a VLOOKUP gives error

    I have created several worksheets including one that holds my look up tables (worksheet labeled tables). I also have another worksheet called "Directions". In the "Tables" worksheet I have an array with three columns, the first holding the text value I am searching for, column two which contains...
  10. K

    fixed a hyperlink

    hi, i need to hyperlink my data from 1 tab to another tab in the same workbook. but i often need to insert data and my hyperlink will all run. is there anyway to fix a hyperlink to that particular data so that when i add new data on the hyperlink page, it will fix.
  11. L

    VBA Code not keeping hyperlinks when pasting

    Hi all, Have some VBA code that copies data from 1 list and then pastes any entries that don't already exist. The issue that I have is that in column A the cells also has a hyperlink and some formatting. Code is below if anyone is steer my in the right direction. Cheers Sub CopyUnique()Dim...
  12. M

    Hyperlink Problem

    Hello and thank you in advance if you can help, I am using excel 2019 64 bit on a PC. I have a VBA macro that I have used to create hyperlinks in the past. It has always worked fine, and it "sort of" is working now, but it is not keeping the absolute hyperlink I need, so it will not open the...
  13. S

    Hyperlink with vlookup formula not working

    Okay I give up I have tried this multiple ways and both ways my formula shows up correctly however its not taking me to the cell I am requesting. I am really new at excel so I apologize if I don't make sense thank you in advance I really appreciate the help...
  14. S

    transfer Text from one textbox to another as a Hyperlink.

    Afternoon all I have a Userform where I can select a file using FileDialog. When I select the file and press Open the file does not open, but the address of this file is pasted into textURL. When I then press the command button "Add" this line of text is added to a textbox "txtFile" within...
  15. C

    Built Hyperlink does not work in some cases

    I have a working subroutine that creates a set of hyperlinks in a 'table of contents'. Unfortunately the hyperlink that is created is not working, in a few cases. Context Example reduced in size for clarity Workbook with five tabs and the table of contents tab Workbook worksheet names...
  16. C

    Change "Display As" text for column of unique hyperlinks

    I have a column of values where each row is a unique hyperlink target. Currently, the labels (Text to display) is the unique hyperlink value. I would like to change the label for the entire column so that every row displays "Master TT" but maintains the unique hyperlink value for each row...
  17. B

    Rename File from Hyperlink on a Sheet in Excel VBA

    I have a sheet which lists many relative hyperlinks. The 'text to display' is the filename. Using the 'Worksheet_Change' event to monitor, if a user changes the filename in the cell the actual filename should be renamed to the new value, so the user doesn't have to open the folder and manually...
  18. W

    Auto hyperlink

    I'm trying to use a button to auto insert hyperlinks for a selected range of cells based on the text inserted in these cells. The text would be a serial number (PDA007 for example) and the hyperlink will open a PDF of the same name. I can do this if all the PDF docs are in the same folder using...
  19. E

    Error on "Hyperlink to a Hidden Worksheet" - Podcast #1729

    Good Morning, I have followed step by step the above tutorial but am getting an error. The code that I typed is the following: Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) LinkTo = Target.SubAddress WhereBang = InStr(1, LinkTo, "!") If WhereBang > 0 Then...
  20. C

    Edit "Display Text" of column of unique hyperlinks

    I have a column of values where each row is a unique hyperlink target. Currently, the labels (Text to display) is the unique hyperlink value. I would like to change the label for the entire column so that every row displays "Master TT" but maintains the unique hyperlink value for each row...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top