Consulting

Results 1 to 9 of 9

Thread: Follow Up Question About the Ribbon

  1. #1

    Follow Up Question About the Ribbon

    I was looking at this http://www.vbaexpress.com/forum/show...-form-question my curiosity is, can I do the same with an Editbox on the Ribbon? I was trying to replicate this and got nowhere. I tried adding "style" to the xml but no go.

  2. #2
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,137
    Location
    Moderator bump
    Please take the time to read the Forum FAQ

  3. #3
    JKwan my curiosity is what is an editbox and how do I add it to a ribbon? I tried to answer this but I got nowhere.
    -I HAVE NO IDEA WHAT I'M DOING

  4. #4
    Mincus, thank you for having an interests with my question.
    Basically, I created an Editbox / Textbox in the Ribbon with XML code
    <editBox 
    id="editFindCaseNumber" 
    imageMso="CalendarViewZoom" 
    label="Find Synergi Case #" 
    screentip="Find Synergi Case Number" 
    showImage="true" 
    onChange="editFindCaseNumber_onChange" 
    getText="editFindCaseNumber_getText"/> 
    
    
    Formatting tags added by mark007
    Now, I tried adding a Style attribue to it, to give it a background color, but Style does not exists (well, it does not like it when I perform a validity check).
    I attached an example file with the Editbox control in the Ribbon
    Attached Files Attached Files
      To view attachments your post count must be 0 or greater. Your post count is 0 momentarily.
    Last edited by JKwan; 11-10-2017 at 07:31 AM.

  5. #5
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,485
    Location
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  6. #6
    thanks md, from the chapter title and scanning thru it, it talks about Listbox and Combobox, so I don't think that will help me.

  7. #7
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,485
    Location
    He part wrote a book on the ribbon. I would try posting in his forum
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  8. #8
    I don't think that BG color is controllable

    https://msdn.microsoft.com/en-us/lib...ffice.12).aspx

    Why do you want to do that? Cosmetics?


    You could use a UserForm (you already know that) that is called by a ribbon button, gets displayed, takes user input, and get updated
    Paul

    ------------------------------------------------------------------------------------------------------------------------
    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s)
    (multiple files can be selected while holding Ctrl key) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  9. #9
    1 - for curiosity
    2 - cosmetics

Posting Permissions

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