Codejock Developer Community : Display popup menu for drop down push button http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 12 May 2026 21:55:53 +0000 Wed, 16 Apr 2008 22:44:47 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=10265 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Display popup menu for drop down push button : Oh dear ... don&#039;t I feel...]]> http://forum.codejock.com/forum_posts.asp?TID=10265&PID=33793&title=display-popup-menu-for-drop-down-push-button#33793 Author: RedFin
Subject: 10265
Posted: 16 April 2008 at 10:44pm

Oh dear ... don't I feel stupid

I had copied and pasted the code from one of the samples, so never even saw the intellisense popup in the IDE. I had been looking for things like popup.top etc.

Thanks wlcabral.]]> Wed, 16 Apr 2008 22:44:47 +0000 http://forum.codejock.com/forum_posts.asp?TID=10265&PID=33793&title=display-popup-menu-for-drop-down-push-button#33793 <![CDATA[Display popup menu for drop down push button : Did you try the x,y parameters...]]> http://forum.codejock.com/forum_posts.asp?TID=10265&PID=33790&title=display-popup-menu-for-drop-down-push-button#33790 Author: wlcabral
Subject: 10265
Posted: 16 April 2008 at 10:36pm

Did you try the x,y parameters ?
 
Public Function ShowPopup( _
   Optional ByVal Flags As Variant, _
   Optional ByVal x As Variant, _
   Optional ByVal y As Variant _
) As Long

Parameters

Flags
The flags of the popup
x
The x-coordinate where the popup menu should be shown
y
The y-coordinate where the popup menu should be shown
]]> Wed, 16 Apr 2008 22:36:56 +0000 http://forum.codejock.com/forum_posts.asp?TID=10265&PID=33790&title=display-popup-menu-for-drop-down-push-button#33790 <![CDATA[Display popup menu for drop down push button : Hi, I am using a drop down push...]]> http://forum.codejock.com/forum_posts.asp?TID=10265&PID=33788&title=display-popup-menu-for-drop-down-push-button#33788 Author: RedFin
Subject: 10265
Posted: 16 April 2008 at 10:02pm

Hi,

I am using a drop down push button and displaying a command bar context menu when the button is clicked, using this code -

Private Sub cmdChangeStatus_Click()
Dim Popup As CommandBar

    Set Popup = gRbn.CommandBars.ContextMenus.Find(400)
    With Popup
        Select Case ebStatusCode.Value
            Case "OP": .Controls(1).Enabled = False
            Case "PA": .Controls(2).Enabled = False
            Case "PC": .Controls(3).Enabled = False
            Case "CL": .Controls(4).Enabled = False
        End Select
       
        .ShowPopup
    End With

End Sub

The problem is that the popup context menu appears where the mouse was clicked ... that is, over the push button.

Can anyone tell me which methods/properties I can control the position of the popup so that it appears at the base of the push button ... I've looked and looked through the help, but can't work out what to use.

Alternatively, is there some other method I should be using??


Cheers,

Rohan]]> Wed, 16 Apr 2008 22:02:04 +0000 http://forum.codejock.com/forum_posts.asp?TID=10265&PID=33788&title=display-popup-menu-for-drop-down-push-button#33788