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...
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...
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...
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...
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:
Dim Sh As Worksheet
Dim Rng As Range
Dim Cell As Range
On Error Resume Next
Set Sh =...
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...
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...
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 "
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.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1...
Can someone help with this simple task please.
I'm trying to get the hyperlink in the outlook body just to read;
Please Click Here to view the [B7] - [B8] event sheet.
where "Click Here" would be the hyperlink. The code I have at the moment is
Private Sub CommandButton3_Click()...
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...
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.
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...
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...
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...
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...
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...
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)