excel hyperlink to nothing

by

You will be better off using the HYPERLINK() function. You can use it for what you want like this:

=HYPERLINK("#HyperlinkClick()", "Text you want to Display")

Notice the # at the beginning. This is important.

Now create a function called HyperlinkClick:

Function HyperlinkClick()

    Set HyperlinkClick = Selection
    'Do whatever you like here...
    MsgBox "You clicked on cell " & Selection.Address(0, 0)

End Function

Be sure to place this function in a STANDARD CODE MODULE.

That’s it.

More Related Contents:

  1. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  2. Running VBA from a HYPERLINK()
  3. delete Autofilter Field resullt using the header Name
  4. Somehow it’s not copying [closed]
  5. VBA macro that search for file in multiple subfolders
  6. So, I have 6 “master” files to then divide into 40 separate files
  7. Getting ScriptControl to work with Excel 2010 x64
  8. Count and Highlight keywords within phrases
  9. Transpose a range in VBA
  10. Protecting cells in Excel but allow these to be modified by VBA script
  11. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  12. Detect merged cells in VBA Excel with MergeArea
  13. Parse HTML content in VBA
  14. How do I name a spreadsheet automatically, by referencing two cells?
  15. Excel VBA Delete Rows
  16. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  17. Should I turn .CutCopyMode back on before exiting my sub procedure?
  18. VBA: How to delete filtered rows in Excel?
  19. Determine whether user is adding or deleting rows
  20. How to use VBA SaveAs without closing calling workbook?
  21. excel vba- extract text between 2 characters
  22. Round function in Excel, worksheet function vs VBA
  23. Excel VBA Userform – Execute Sub when something changes
  24. Count the number of rows in another sheet [duplicate]
  25. Getting Excel to refresh data on sheet from within VBA
  26. VBA Password Input with Cancel Function
  27. Create hyperlink to another sheet
  28. How do I get a list of unique values from a range in Excel VBA?
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment