Custom context menu with sub-menus

[Formula11]

Is it possible to have a 3rd level of context menu, using traditional VBA coding?

Similar to this example which uses RibbonX.
Customizing Context Menus in Win Microsoft Excel 2010 and higher and also Mac Excel 2016 and higher

 

[Dan_W]

There is, but off the top of my head, it wouldn't look exactly like you have it in the screen capture. It would have to use the smaller "version" like you see in the 1st and 2nd levels (eg, using a smaller ImageMSO, a bitmap, or like the FaceIDs in a previous question I worked with you on). I'm on my phone at the moment, so can't give example code until later tonight, but you'd want to use the CommandBars object.

You could recreate the context menu like you see in your image above. But there would need to be a little bit of XML ribbon work - basically you can create a dynamic menu, and use VBA to write the code, but you will need to at least amend the ribbon XML code in the workbook in order to do that.

 

[Dan_W]

Ahh, here you are, I found an example - it was on the same website, different page: Creating a PopUp Menu that is working in every Excel version

 

[Formula11]

Thanks Dan_W, this is suitable I think.
It looks like a popup menu can be made after the context menu, so this will be able to go to the 3rd level.
Thanks for solving.