Assign macro to right click Context Menu (macro in userform)

[Un-Do Re-Do]

This workbook has 2 new right click context menu items as shown.
When clicked, a macro is supposed to run.
When the macro is written into a Module, it works.
When a macro is written into a Userform, it doesn't work.
Any reason why?

Snapshot.png

Please Login or Register  to view this content.

[Logit]

.
If not already done ... place the macro in a REGULAR module, not the UserForm.

In the UserForm ... reference a call to the macro.

[Un-Do Re-Do]

@Logit, I had this before with the code in a regular module. I want to have in the Userform because of other modules and want to use common declarations, etc.
Was hoping that something like "'!UserForm1.MacroInForm" would work.
Should I assume it's not possible?

[Logit]

.
Paste this code in the UserForm :

Please Login or Register  to view this content.

Note: It gives you immediate access to the single macro.

[romperstomper]

You cannot call a routine in a userform like that. It will have to be in a normal module, which I would suggest is where it belongs anyway.

[Logit]

.
The suggestion in Post #4 does work.

[romperstomper]

But not for the Cell shortcut menu.

[Logit]

.
As the OP presently has code written ... and his request was to provide for a "right click" access on the UserForm to run a macro ... the code does what he is requesting.

He has been instructed "Note: It gives you immediate access to the single macro." ....meaning the right click will only run the macro as presently designed/written.
It caused the MsgBox to display.

Your observation is accurate ... the #4 suggestion does nothing else.

It will be up to the OP to include additional code for the macro to provide the goal / s he is seeking. That could be a "Select Case" statement, initialize another UserForm or some other code
for his purposes.

I am curious for the purpose/s he intends ... especially as there may be other avenues he could take that might be more effective or easier for the end user.

[romperstomper]

.and his request was to provide for a "right click" access on the UserForm to run a macro

That is not my interpretation, based on the question and the code posted. I believe the OP wants an item on the right-click cell menu to directly run a routine stored in a userform, which isn't possible. It would require an intermediate routine to load the userform and run the code in it.

[Logit]

.
Possibly. We will see ....

[Un-Do Re-Do]

The discussion above is worthwhile.
The right-click item is supposed to run a routine within the form. From post #9 I gather this is not possible.
Thanks for the effort.

[Logit]

.
What routine is to be run ?

[Un-Do Re-Do]

@Logit, it's used to run the code which:
Looks at cell strings and colours each character based on the font of the character.
Unfortunately the code can't be written due to the following error: "Access Denied - Sucuri Website Firewall".
Please see attached.

[romperstomper]

I can't really see why that code should be in a userform?

[Un-Do Re-Do]

@rorya, there are other modules in the form, as well as some common declarations.
Anyway I've taken it onboard to have it in a module.

[romperstomper]

there are other modules in the form

I guess you mean routines, since a form only has one module? Even so, that doesn't mean that routine has any real business being in the form, since it dpoesn't appear to relate to a userform in any way. And especially not if you need to call it from elsewhere.

[Un-Do Re-Do]

@rorya, I understand the but the user usually has a reason for the requirement.
There is a button in the form which also call up the same routine. There are several other routines within the form which are similar in nature.
The code posted is simplified to try and get an answer.
Understand and appreciate the holistic advice but a lot of the time user has a reason.
In any event for this case, there was no option but to separate the routines into different modules.

[romperstomper]

Why would it matter to the user how the code is implemented?

[Un-Do Re-Do]

Sorry but by "user" I meant myself.
The Project is quite large with many modules and routines. It's just a way for me to rationalise.

[romperstomper]

Gotcha.

Not what I would call good practice, for what that's worth.

[Un-Do Re-Do]

Point taken.