Forum Discussion
rkisselbach
Nov 15, 2022Copper Contributor
Find link reference in Excel
I hope someone can help me with my issue.
Every time I start I get a notifciation to update external links. The two links listed are to two seperate spreadsheets.
I already searched the sheet and the workbook with *.xl* but no result. I've checked the Name Manager as well as all macros.
Is there another way to find out where the link refernce is been used?
Thanks for your help.
I don't see anything wrong with your syntax. Guessing you had some other code in this module that was causing your issue:
Sub GuessName() Msg = "Is your name " & Application.UserName & "?" Ans = MsgBox(Msg, vbYesNo) If Ans = vbNo Then MsgBox "Oh, never mind." If Ans = vbYes Then MsgBox "I must be psychic!" End Sub
If your new to VBA, then maybe it will be helpful to know the different arguments associated with MsgBox. Some of the arguments like Button and Title can make your VBA solution more polished looking and allows for greater customization.
Check the MsgBox arguments out here:
https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/msgbox-function
2 Replies
Sort By
- Detlef_LewinSilver Contributor
- rkisselbachCopper ContributorThank you for the links.
The issue is now solved through these links and an Excel Add in that looked for the links as well.