I'm not sure if this is complicated or if I am making it complicated in my mind.

Objective: I would like to add a new item on the right-click context menu in excel. When this new item is clicked I would like it to open up a designated user form.


So far I have figured out how to open a user form by overriding the right click menu completely and opening the user form. However, I want the user form to open only when selected on the right click menu.


Is this complicated? If anyone has idea, guidance, or the solution that would be helpful.