gallery

  1. bs0d

    Excel Ribbon - Styles Gallery? Group

    I'd like to create something similar to the Excel Styles ribbon item, that looks like this: I thought it might be a gallery, but when I try that element, I get something that looks like this instead: How can I have this box to display the contents, with a button to expand? I may have only...
  2. S

    Table Styles

    I have created a table style in my Persoanl workbook but it does not appear in the gallery on other workbooks. Is there a way of creating a style that will always be available? I am using Excel 2010 on Win 7
  3. PetLahev

    Ribbon Gallery - GetItemLabel

    Hi, I've created my gallery where user can choose my color (I need more colors than the themes offers) and I use a label of each item like RGB value. My question: How can I get label of item in VBA callbacks? Look at Ribbon's code bellow (I had to put it as image) and here is my code in VBA...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top