Thread: How do I replace the default msgbox for circular references?

When a circular reference occurs, the circular reference msgbox comes up asking if I would like more info, or cancel if I want to continue. Is there a way to replace this msgbox with my own? I would like to add some additional options to the message, but I can't seem to figure out how to replace that other message box.

Bump, no response.

I think the best whould be making your own userform.

You call up the userform which u make labels and buttons in how ever you want it.
when the user clicks 1 of the buttons you have created in that screen you can make your own desired script of actions.

Thanks for the advice. I guess my issue is, how can the event of creating a circular reference trigger my code?

My code would then bring up the msgbox/userform with the options that I want.

this depends when you want to create it.

you can start this per button which is a easy way or start it when something happans in the Sheet or Workbook which trigger a script.

if you do it per a button which will event a macro then your code in this will be:

load "your userform name"

hope this helps u a bit