I'm making a database in Excel where all the entries are stored on one sheet and a search tool will bring any wanted information to a different sheet. I want to be able to make changes on the search sheet and never have to visit the storage sheet.

Currently I have been able to make changes to the values of the cells on the search sheet and have those changes affect the database sheet in the correct way using a worksheet_change event. The problem is that this change event does not fire when a hyperlink is added or changed as the actual value does not change.

I was wondering if there was an event that will fire when a hyperlink is changed/added.