Note 2 - Finding a button object name in VBA This method is robust as the Control ID is unique and fixed Method 2: If ButtonItem.ControlID = R_Joke_G1B2.ControlID Then If the Label changes name or if the button has the same label as another button then you can get errors. Anywhere in VBA just type 'CTRL + Space' then start typing in your button label to find it. If you type in enough text that it is unique to a button object name then its full object name will be inserted. So in this example I typed 'R_J' then 'CTRL + space' then the full name 'R_Joke_G1B2' was inserted. (Optional) Add code to set rules for dynamic changes to your ribbon. This example code below greys out buttons depending on what sheet is selected.Īs you develop your ribbon with Easy Ribbon Builder you'll notice that there is a column titled 'VBA object name'. These names are computer generated and when you publish it, Easy Ribbon Builder will define all ribbon items as objects using these names. These objects make it very easy to read or write ribbon item properties with VBA code. 'R_' at the start allows the user to easily filter for only the ribbon items.The item label is then included so the user recognises the item.GX where X is the group number 1-10 (not for ribbon tab item).BX where X is the button number 1-10 (not for ribbon tab or group items).MX where X is the menu number 1-10 (only for drop-down or split buttons)Īll ribbon item objects that Easy Ribbon Builder has defined in VBA can be read or written.

The only exception is ControlID which can only be read. Just to be 100% clear, the argument ButtonItem in the Button_Click procedure refers to a ribbon item but is not a ribbon item itself. ButtonItem can only be read but not written. This is used as a argument in the Button_Click procedure, it refers to a button item but is not the button item itself If ButtonItem.ControlID = R_Joke_G1B2.ControlID thenĮrror - ButtonItem can only be read. This is a list of ribbon item objects in RibbonObjectsDefined module. These objects make it very easy to read or write ribbon item properties with VBA code.įor a full list of these objects, simply type 'R_' anywhere in VBA code > Press CTRL + Space Easy Ribbon Builder has automatically defined these objects for you. R_Label_GXBX.Label (Button label String read write) Properties: (Where R_Label_GXBX represents a button name) Developer tab excel ribbon full#

Best necro b10 monsters