hyperlink construction

  1. L

    VBA Macro Create Hyperlink out of Cell Value contents

    Hello All, I'm trying to create a series of Macros that take the contents of Column E, puts a direct hyperlink to website in question. I just can't seem to find the code online to help me achieve what I want. This is the code I have so far. Dim sh1 As Worksheet Dim...
  2. M

    Conditional hyperlink onto a shape

    Hello all, I have a project I've been working on and up till this point I've been using shapes to link to other sheets within the workbook. However, I would like to add a new "current stage" button that will send me to a specific sheet depending on the value in cell A5 in Sheet1. I'm pretty...
  3. S

    Opening multiple Hyperlinks from a table containing hyperlink data tags

    Hi all, I am new to the forum. I am writing a sheet (link sheet) that includes a number of Hyperlinks (6-700) and I am including tags against each hyperlink; some of the hyperlinks will have more than one tag. I want to create one hyperlink on another sheet (master sheet) in the same workbook...
  4. B

    Excel data to Google Map Location

    Hi,Im new here but I have a minor Excel issue. (I use Excel 2010 for my sins)I have a list of adresess and postcodes in an excel table.Each property has a unique identifier and I currently have a enquiry sheet that runs several Vlookuups and returns all of the site details when a user inputs the...
  5. S

    How to add Hyperlinks of multiple folders to multiple lines of a spreadsheet.

    I work in sales and I have a list of schools that I do business with. In the spreadsheet it has the school name, tel number, postcode address etc. I have notes for each account or line in notepad documents on my PC. I need to be able to link all of the correct notes to the respective...
  6. J

    Hyperlinked Names In DropDown Box

    Hello, I have a spreadsheet with the same dropdown list in each cell of one column. I would like each drop down list to behave in the following manner: When a user selects the appropriate name from the drop down list the name turns into a "blue colored" active hyperlink to an...
  7. M

    text string seach and count???

    Alright i have a term i want to search say "Large Dog" I have a list of about 200 rows of files (located in a few main folders on my computer) that i want to search through each of the text strings. Is there a way that i can search through the entire list and have the formula return return a...
  8. A

    Hyperlinks between two cells

    Hi folks I have two workbooks one which contains a list of experiments and the other which contains the experiment data. I am trying to write a macro that will go through the list in the first book and the experiments in the second and create a hyperlink between a name and the corresponding...
  9. M

    Cell Address in =Hyperlink

    I want to use a cell address as the "link to:", of a =Hyperlink construction. The cell contents are dynamic and must be constructed from a conconacation of two cells. Thanks

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top