hyper link

  1. K

    Hyperlink formulas disappearing after a running code

    I have a spreadsheet with nearly 5000 defined names. We have a code that transfers filled out information from the template, to the most recent release of that template to capture any changes in sale prices or new items. So they are both the same spreadsheet except the most recent template has...
  2. Y

    Attachements and Hyperlinks in an Excel UserForm (HOW TO)

    I have created an Excel UserForm that I am using to track employee coaching documentation and the Action Planning process. I am wanting to know how to create an option to select and upload and attachment, have it saved to a Shared Drive on our network then create a link that would be on the...
  3. R

    Select Cells based on other Cells Value

    Hello Everyone, I am working on database and need your help in one macro. I have one drop down linked with V1 and have one search box. V1 will be the country name. So i want If V1 is australia then C8:P9 should be selected and cursor automatically reach on C3. Same if V1 is Austria then...
  4. X

    Conditional Hyperlink with drop down list

    I have a drop down list with 4 options - A, B, C, and D. I need that only when C is selected from the list, the cell itself has a hyperlink. So, if cell B4 gets the value C from the drop down list, then C or the cell itself should be hyperlinked to say Google.com. If any other value is selected...
  5. D

    VBA - Find Hyperlinks in column from a specific domain and open in browser

    Hello Everybody, I need your help guys. I am trying to find hyperlinks in a column and open them in my default browser. I am currently using this: Sub openlink1() 'Open Links Dim Sh As Worksheet Dim Rng As Range Dim Cell As Range On Error Resume Next Set Sh =...
  6. L

    Hyperlink as Button for VBA Code

    When I was researching why my command buttons keep changing size, I came accross a comment suggesting the use of hyperlinks or images instead. I like the idea of a hyperlink as it would fit better on my dashboard, but I'm not sure wher to start. Does anyone have the method for attaching...
  7. P

    Display a table in a pop-up window when a hyperlink is clicked

    Hi Everyone, I was wondering if there is a way in excel-vba to do this. In sheet A, I have 10 tables. Each table is assigned a table name and has two columns (a list of fields in column 1 and the corresponding data types in column 2). I have added a hyperlink to the cell which contains the...
  8. A

    Coding for macro to open link - help with code?

    Sub FollowLinks() Dim i As Hyperlink If (A1) = " http://www.ecb.int/stats/money/aggregates/bsheets/html/outstanding_amounts.zip " Then OpenLinks " http://www.ecb.int/stats/money/aggregates/bsheets/html/outstanding_amounts.zip " End If End Sub Can...
  9. T

    VBA Code to target specifc range

    Hi All, I have a VBA script, which works for the whole column which when clicked it allows the user to select a hyperlink file or folder from the computer and it will insert the link into Excel. Code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1...
  10. A

    Click Here

    Can someone help with this simple task please. I'm trying to get the hyperlink in the outlook body just to read; "Hi Please Click Here to view the [B7] - [B8] event sheet. [B9]" where "Click Here" would be the hyperlink. The code I have at the moment is Private Sub CommandButton3_Click()...
  11. S

    Hyperlinking/Data Validation?

    Hello All, I have a hyper-linking or possibly a Data Validation question. I have Sheet 1, with a bunch of customer on it(Each customer has their own row). It also has some financial data on it as well, but not important. I also have Sheet 3, which is a Pivot Chart of all the customers on...
  12. B

    VB Code for Hyperlink

    I have a spreedsheet that several users enter data at different times.I am currently having it emailed using a macro. Is there code for sending a email that will just contain a hyperlink back to its point of origin. (This is all done on a Network). Thanks again. This Forum is amazing.
  13. B

    Grouping Columns

    I previously had a sheet running with 4 sets of columns grouped, and I have also with the help of people on this website added code so that should I be following any of the internal hyperlinks which are minimized in a closed group, they become visible. Recently the sheet crashed and since it...
  14. B

    Excel Cell links

    Hi guys, I need some help linking two cells in the same work sheet. I want to be able to click on a cell and it take the viewer to the related cell elsewhere in the spreadsheet... I can do this with a hyperlink but my issue comes when I move the linked cell to a new location. The link then goes...
  15. motherteresa

    Email Hyperlink Issue

    I have searched, but just can't get this figured out. Any help would be SO appreciated. I have this code in a sheet. The code is activated by clicking on a button. It all looks great, but I want my email address to be a hyperlink. I've read several solutions, but can't seem to get it right...
  16. E

    Hyperlink Issue/Formatting Problem

    Hey There, I am experiencing an issue within an Excel workbook dealing with hyper links. I have created a navigation tab with links to all the other tabs within the workbook. I added "Home" links in the top left corner of every tab that links back to the main "Nav" tab. Every time I open the...
  17. B

    Excel 2003 Listbox hyperlinks

    I have a userform I am working on that basically acts as an advanced filter. I am barely versed in vba so I put my mild skills to use by editing a template. One of the functionalities that it is missing is that I can't seem to get the filtered items that show up in the listbox to be clickable...
  18. R

    Segregating Hyperlink & HyperText - Please Help

    I have a spreadsheet with a Hyper Link and Title of the hyperlink in column "A" and I want to show the actual URL code in Column B by Referencing the data in Column A. Please Help
  19. H

    Combo List Box Issue (sort of)

    I need help once again. In a worksheet I have a drop down list box that reads from range A5:A7. (the text "Option 1" is in cell A5, "Option 2" in A6 and "Option 3" in A7) This drop down list box is linked to cell J9 (and displays the text that was selected in the drop down list box) My Goal...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top