Consulting

Results 1 to 9 of 9

Thread: Follow Up Question About the Ribbon

  1. #1
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location

    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 Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Moderator bump
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Tutor MINCUS1308's Avatar
    Joined
    Jun 2014
    Location
    UNDER MY DESK
    Posts
    254
    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
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    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"/>
    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
    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,489
    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
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    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,489
    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
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    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


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    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) / 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
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    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
  •