Results 1 to 2 of 2

Thread: Populate Ribbon Controls On Load Dynamically Through VBA Variables

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Apr 2013
    Posts
    1
    Rep Power
    0

    Populate Ribbon Controls On Load Dynamically Through VBA Variables

    I am working with custom ribbons for an Excel file that i am working on. I have got to the point where i can Load the ribbons/controls and have them function as expected. My question is, however, how do you dinamically change list items in a control based on the end user response. For example, I want a control for month and year (Jan 13 - Dec 13). But, I want it to be limited to a variable of my choosing. Lets say I only want to display Jan 13 - Mar 13 because May 13 isn't here yet. But next month, i want it to list May due to a particular user action.

    I hope this is clear enough and thanks in advance for anyones help.

    Patrick

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Have a look at the Chronos Twelve Add-in in this forum. If you know what you're doing, you'll be able to figure out exactly what I've done to create a dynamic ribbon. You can adapt it to build anything feasible within the ribbon realm.

    If you still aren't able to figure things out, post your file, let me know exactly what you are trying to do.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Minimize/Maximize Ribbon using VBA
    By LalitPandey87 in forum Excel and VBA Tips and Tricks
    Replies: 10
    Last Post: 06-10-2013, 09:26 PM
  2. Hide Ribbon, Gridlines, Heading and FormulaBar using VBA
    By LalitPandey87 in forum Excel Help
    Replies: 7
    Last Post: 06-10-2013, 04:41 PM
  3. Replies: 3
    Last Post: 03-05-2013, 03:57 PM
  4. Load PNG File in Userform Image Control
    By Tony in forum Excel Help
    Replies: 2
    Last Post: 02-14-2013, 01:21 PM
  5. Add ribbon programmatically to Excel 2010 using VBA
    By heapifyman in forum Excel Ribbon and Add-Ins
    Replies: 6
    Last Post: 07-18-2011, 09:16 PM

Tags for this Thread

Posting Permissions

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