Hi all,
I am new here and new to VBA coding. I am using and modifying an Excel VBA subroutine that generates a Word document with tables populated with information. Now I'm looking to add a snipet of code that lets me turn text in selected cells into hyperlinks.
This is what imo relevant parts of the current code look like:
Now I'd like to encode that e.g. hyperlink X is added to TEXT A in Cell (2,2).
Please Login or Register to view this content.
Does someone know which code to use?
Last edited by alansidman; 10-18-2023 at 03:51 PM.
Code Tags Added
Your post does not comply with our General Guide lines. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html
(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
However, if you continue to not use code tags, you can expect to have your thread BLOCKED until you add them yourself.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I don't know if I understood you correctly. The following code will insert the hyperlink after TEXT A.And if you want to insert a hyperlink into Cell(2,2) and display TEXT A in that cell, then like this:Please Login or Register to view this content.ArtikPlease Login or Register to view this content.
Hi Artik, I tried the 2nd one and it worked. Fantastic! Thank you so so much!OZ77
Last edited by OZ77; 10-19-2023 at 09:17 AM.
One follow-up question though (not a new request): I also want to add the same hyperlink to a bunch of different cells, either adjacent cells or cells dispersed over the table. Is there a smart way to do that? As opposed to the stupid way of having to encode one-by-one the same hyperlink to a bunch of individual cells.
If you want to insert a hyperlink to all cells of a specific column (in the example, to the second column), you create a loop that will "run" through the rows of the table, and then point to the second cell in each row:In case the cells are scattered around the table, create an array to store the cell addresses. Each address consists of a row and column number separated by a comma and must be separated by a space:Please Login or Register to view this content.The Split function will create elements containing the address of each listed cell. The second Split function will return the row number and column number of each cell.Please Login or Register to view this content.ArtikPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks