Open right click custom menu below command button

[amrut]

I use

Application.CommandBars("InvoiceMenu").ShowPopup

to show the menu.The menu opens at the cursor location.



How to specify the X and Y values in Application.CommandBars("InvoiceMenu").ShowPopup X,Y to open the menu exactly below the command button as in second figure above. I think the X and Y values are screen related and the command button's left bottom corner's X and Y screen coordinates are required.

[rpeare]

Me.ControlName.Top
Me.ControlName.Left

these command will give you the top left corner

if you want to get the bottom left corner you maybe able to do it with

Me.ControlName.Top + me.controlname.height
Me.ControlName.Left

[amrut]

That doesn't work. The X and Y parameters in the ShowPopup method area are screen related. If the form is a popup one and it is moved, the Top and Left values of controlname do not change but the X and Y parameters change. I have tested it using Debug.Print Application.CommandBars("InvoiceMenu").Top & Left. The command button's left bottom corner's screen related X and Y coordinates are required.

[rpeare]

it seems to me you're a bit stuck then because you're looking for a screen related coordinate pair for an application that don't really talk to one another.

You can get screen related coordinates but they won't relate to your control, they'll relate to where your cursor is
You can get application related coordinates but, as you pointed out, they won't relate to the screen coordinates.

If you find a solution I'd like to know it but I don't know that you'll find one.