As being very unfamiliar with VBS, this video was a great breakdown of what to do step-by-step. I appreciate this so much because I am the type that needs things broken down as well as a visual aid. So watching this video and having you explain it was beneficial to me to reference for future use. Thank you!

This application seems way above my knowledge of Excel and code writing. It would be interesting to explore this more.

Thank you Dr Grande for posting this video. I find VBA hyperlinks very useful to navigate inside large workbooks, between workbooks and externally. I am interested specifically in the situation where the hyperlink is not valid. One question to you: I have a workbook with many hyperlinks (over 100) created (some automatically, some manually). Is there a way to loop through all cells which contain a hyperlink and test validity of each link without necessarily opening the destination workbook or web page? My initial preference goes towards automating as much as possible the code: ; however, in large projects where different files get sent to different customers (with different names), this may prove difficult to achieve 100%. I am thinking testing whether a and exist; but again, I believe I would need to open the destination file to test whether the link is valid or not. Your thoughts would be truly appreciated. Thank you

Thank you Todd

@DrGrande

6 жыл бұрын

You are welcome!

I want to change multiple numbers/dates in a cell in a userform in excel vba by a spin button. How can it be possible ?

I have a Master Excel Workbook in which i have linked the relative documents using hyperlinks. These workbooks open when i click on the Hyperlink. i have also created a back Link to Direct back to the Master. But in the process when i get directed back to Master Excel Workbook the Other Workbook which opened by clicking hyperlink remains open. I want those opened workbooks to close when i click back to master file. Is there a way in which i go directly to the master Excel Workbook by simultaneously closing the other Workbook.

I used Visual Basic and this looks familiar. I am wondering why a hyperlink would be needed when calculating data?

What if we want to open a hyperlink from the website we just navigate.... For example the code will take us to a website (amazon.in) from there i want to click START HERE hyperlink.... Any idea please replay back

I used your VBA code to open a workbook, but when I hit cancel, type in the wrong password, or just close the box, they ALL take me to the workbook. What shall I do to remedy this?

Useful information, should I need I can now add a hyperlink.

@lizconnor1820

7 жыл бұрын

I agree, this video is useful in the event we needed to add a hyperlink to a worksheet. It looks like a rather advanced function so I cannot imagine using it in our current course. But, overall, another helpful video.