+ Reply to Thread
Results 1 to 5 of 5

RibbonX Custom Dropdown Not Firing

  1. #1
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    RibbonX Custom Dropdown Not Firing

    I've created a custom Ribbon tab with several working Command buttons, etc. using Ken Puls info and Andy Pope's editor.

    I have a Dropdown control that is very finicky and I'm not sure what is wrong. I modeled it after Ron deBruin's DD example setup and it works some of the time and others, doesn't respond at all.
    Here is the code:
    Please Login or Register  to view this content.
    It is the code in the Case-Select of ddFactbook which is not being triggered. I've tested running the individual procedures outside of this Dropdown setup and they work just fine.

    This is an image of the Tab showing the list of possible selections:Factbook to use.png

    Suggestions?

    Thanks in advance,
    Delain

    Note: This is cross-posted at http://www.eileenslounge.com/viewtop...216324#p216324
    I say this optimistically . . . One day I'll understand it.
    But today is not that day!

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    830

    Re: RibbonX Custom Dropdown Not Firing

    I prefer to Use Ribbonx with Callbacks, and think better to save as an Excel Addin vs a Persoanl WP.

    Take a look at the attached and see if helps. You may be able to swap in your code for each call back. Or upload a sample file and we can take a look.
    Attached Images Attached Images
    Attached Files Attached Files

  3. #3
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: RibbonX Custom Dropdown Not Firing

    Thank you for pitching in here.

    My custom menu is indeed in an XLAM file which is where all of my Callbacks and the code for RibbonX, and the problem code I sent, is located. The called procedures which are in the Case-Select section (Run "Personal.xlsb!factbook2017") are located in my Personal.xlsb file. What is frustrating with this is, I have another DropDown setup, exactly like the Factbook setup and it works every time. This Factbook setup is very finicky and has now stopped working all together.

    Okay, I'm missing something very simple with your example. Where is the XML code that defines how the Home tab is modified and populates the Dropdown?

    Thank you,
    Delain

  4. #4
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: RibbonX Custom Dropdown Not Firing

    Sorry for the bother. I was trying to open your XML portion as a CustomUI14. Now, when I simply use the 2007(?) to open in the Ribbon editor, I can see your very simple code setup.

    Thank you for this. I will consider possibly changing mine. Would still be good if I could figure out why Ron's setup, which I've adapted, is not working here as I posted.

    Still looking for a suggestion.

    Thank you,
    Delain

  5. #5
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    830

    Re: RibbonX Custom Dropdown Not Firing

    Quote Originally Posted by delaing View Post
    Thank you for pitching in here.

    Okay, I'm missing something very simple with your example. Where is the XML code that defines how the Home tab is modified and populates the Dropdown?

    Thank you,
    Delain
    The XML code for the menu will not be inside the VBA. If you google RibbonX you will find the easiest way is to use a small program called CustomUI Editor to create your own menu info. You could also go the 'hard' route and open the excel file with WinZip, 7zip and navigate to the customui folder and xml data.

    I have all of my RibbonX, call backs and macros all in my Addin file. There should really be no need to have a separate Persanal.xlsb file.

    EDIT. I think you will find the CustomUI Editor program much easier to work with than AndyPope's Editor.
    Last edited by ptmuldoon; 09-20-2017 at 03:07 PM.

+ 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. Custom Ribbonx and Setting Visibility of Groups?
    By ptmuldoon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-11-2016, 04:00 PM
  2. [SOLVED] Custom UI using Ribbonx
    By Beekster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2016, 06:25 AM
  3. Q: OLEObject in custom class, events not firing
    By miguel3d in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2015, 08:45 PM
  4. Excel Custom RibbonX Label updated from VBA
    By Bezzie in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-06-2013, 08:22 AM
  5. [SOLVED] Custom function not firing when a change to the workbook/worksheet has been done
    By thechazm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-16-2013, 10:20 AM
  6. Populate sheet names in RibbonX dynamic dropdown
    By 2Excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2011, 04:51 PM
  7. Custom Dropdown Macro
    By Chef101 in forum Excel General
    Replies: 1
    Last Post: 09-28-2007, 05:28 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