+ Reply to Thread
Results 1 to 2 of 2

strange ribbon dropdown problem

  1. #1
    Forum Contributor
    Join Date
    12-25-2012
    Location
    gent,belgium
    MS-Off Ver
    Excel 2021
    Posts
    146

    strange ribbon dropdown problem

    i made two workbooks VerlofkalenderAcod and KalenderAcodRibbon13
    In the firstworkbook everything works fine.

    To test i select a day on calandarthe worksheet 2018 Than make a choose in the combox.
    depending on the selection on the selected day here come a shape rectangle for a full day of and a triangle for a half day of.
    When you select a rectangle or a triangle you get a massage that you select a shape.

    But a friend told me that a silder and combox on the worksheet are the old method.
    He told me also that the new methode that now is used is make a new tab on the ribbon. And set a combobox for the slider and a dropdown for the Combox.

    When the use make a selection of a day he whant a day of and go to then new tab dropdown and select the holiday code he want to use no problem. He get the wright shape.
    Make he alose a selection that have a shape in it he get a messge that the selection contain a holiday code.
    So far no problem.

    The problem is when he select a shape than it goes wrong and i dont now why?

    What i did in the workbook KalenderAcodRibbon13 is make a copy of all the modules out VerlofkalenderAcod and copy the code that is under the worksheet Verlofkalender Sjabloon or 2018
    To the moduleRibbon under the folllowing part
    Callback for dropdown onAction
    Sub DDonAction ...

    afther the declaration with all the lines that begin with dim
    You find the follwing code
    Set RngVerlofBereik=selection
    I'v get the following message
    Foult 13
    the types do not match

    Why ? Wy it works in VerlofkalenderAcod and not in KalenderAcodRibbon13

    Manny thanks for your help.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-25-2012
    Location
    gent,belgium
    MS-Off Ver
    Excel 2021
    Posts
    146

    Re: strange ribbon dropdown problem

    if found a solution if it the best solution i dont now
    I put the code in the meodule MenuRibbon at the begining of ddOnaction
    Befor we do the set Set RngVerlofBereik = Selection
    Please Login or Register  to view this content.
    Last edited by glda19; 04-25-2018 at 04:45 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. refrech dropdown on ribbon or do onaction
    By glda19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2018, 03:51 PM
  2. A dropdown how to fill on ribbon
    By glda19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2018, 03:27 PM
  3. ribbon custome menu dropdown list outline
    By glda19 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-06-2018, 12:00 PM
  4. Dropdown box in a custom ribbon on click of button
    By benwilson6215 in forum Excel General
    Replies: 0
    Last Post: 07-07-2017, 10:21 AM
  5. [SOLVED] How to make a Dropdown menu in Custom Ribbon
    By eddijensen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2016, 07:53 PM
  6. VBA / XML dropdown in ribbon
    By michiel soede in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2015, 10:35 AM
  7. Excel Ribbon dropdown
    By VWood in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-15-2010, 12:07 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