+ Reply to Thread
Results 1 to 4 of 4

Callback for Ribbon drop down

  1. #1
    Forum Contributor
    Join Date
    06-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    150

    Callback for Ribbon drop down

    I am trying get the contents out of a ribbon drop down box. Most references I've found use ByRef to send info to the ribbon, but I need the opposite. I found a couple of examples using ByVal but I get the error: Wrong number of arguments or invalid property assignment.

    Here are my codes

    XML Code
    Please Login or Register  to view this content.

    And here is the VBA call back
    Please Login or Register  to view this content.
    Your help will be greatly appreciated.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Callback for Ribbon drop down

    the callback for a dropdown is onAction rather than onChange and your callback declaration oughta be
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    06-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    150

    Re: Callback for Ribbon drop down

    That did it!

    1000 Thanks!

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Callback for Ribbon drop down

    you're welcome :-)

    please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filling drop down box when reloading ribbon
    By micklloyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2013, 12:43 PM
  2. Ribbon - Multiple xlam adding into single Ribbon tab
    By gooopil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2011, 03:40 PM
  3. Replies: 0
    Last Post: 07-24-2006, 09:10 AM
  4. Callback for a cell changing with less code
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-10-2006, 06:15 AM
  5. Problem trying to make my DLL callback a VBA function with paramet
    By Thivierge.M in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1