Consulting

Results 1 to 9 of 9

Thread: TextHighlightColor - control, button, gallery, whatever ...

  1. #1
    VBAX Contributor
    Joined
    Apr 2015
    Location
    Germany
    Posts
    167
    Location

    TextHighlightColor - control, button, gallery, whatever ...

    Hi all,

    it seems ridiculous, but I'm not able to get TextHighlightColor into my selfmade addin.

    I tried
    <control idMso="TextHighlightColorPicker" enabled="true"/>
    <control idMso="TextHighlightColor" enabled="true"/>
    <button idMso="TextHighlightColorPicker" enabled="true"/>
    <button idMso="TextHighlightColor" enabled="true"/>
    <gallery idMso="TextHighlightColorGallery" enabled="true"/>
    <gallery idMso="TextHighlightColor" enabled="true"/>

    None of these worked and I wasn't able to find it via google, as all lists of controls I found were too old to have this relative new function included.

    Does anybody know the solution?

    Thanks in advance,
    RG

  2. #2
    it's a gallery and will only be Enabled when your Textbox is in Rich Textbox format:

    <gallery idMso="TextHighlightColorPicker" size="large" label="Hilite" />

  3. #3
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,380
    Location
    Quote Originally Posted by RandomGerman View Post
    too old to have this relative new function included.
    https://www.google.com/url?sa=t&rct=...yI2fOHh6bLRcnc

    The 2018 version has TextHighlightColorPicker

    Capture2.JPG


    I tried to just attach the docx, but it's too large

    I tried to just include the URL of the docx, but Google kept interjecting and I couldn't figure it out

    Try Googling to get

    Capture.JPG
    ---------------------------------------------------------------------------------------------------------------------

    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

  4. #4
    this is but a demo (MS Access).
    on ribbon you will see a custom tab (My Tab).
    TextHighlighColor gallery is Named as "Hilite".
    The textbox Text Format is Rich Text.
    Attached Files Attached Files

  5. #5
    VBAX Contributor
    Joined
    Apr 2015
    Location
    Germany
    Posts
    167
    Location
    Thank you so much, both of you. Unfortunately I cannot open MS Access to have a look on you example, don't have it installed, and I think I don't get the point with the rich text format.

    I copied your code,
    <gallery idMso="TextHighlightColorPicker" size="large" label="Hilite" />
    but it did not make the button visible on my self-made ppam-ribbon, while the function is there and works on the home ribbon, so it shouldn't be a problem with the selected textbox, if I get that point right. I can highlight texts with the gallery on the Home ribbon, but I don't get the gallery visible on my own ribbon.
    As the problem is usually in front of the computer, I guess I'm still doing something wrong, but at the moment I have no idea what. Do you have?

    @Paul: Your google link does work!

  6. #6
    What do you have? Excel or word?

  7. #7
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,380
    Location
    Quote Originally Posted by RandomGerman View Post
    Thank you so much, both of you. Unfortunately I cannot open MS Access to have a look on you example, don't have it installed, and I think I don't get the point with the rich text format.

    @Paul: Your google link does work!
    1. Good

    2. I think / guess (bold, underlined) that the control.id should be "TextHighlightColorPickerLicensed"

    Here's PP example that uses Options, Customize the Ribbon to find the control.id by hovering over the msoId and using the part in parens as the control.id

    (at least I think that's the way it works; I couldn't find my old reference)


    Edit -- I did find a reference

    https://www.add-in-express.com/docs/net-ribbon-tips.php
    Attached Files Attached Files
    Last edited by Paul_Hossler; 01-14-2022 at 06:42 AM.
    ---------------------------------------------------------------------------------------------------------------------

    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

  8. #8
    this is a sample for Excel and Word
    goto Home tab, then Farthest right Group.
    Attached Files Attached Files

  9. #9
    VBAX Contributor
    Joined
    Apr 2015
    Location
    Germany
    Posts
    167
    Location
    Quote Originally Posted by Paul_Hossler View Post
    2. I think / guess (bold, underlined) that the control.id should be "TextHighlightColorPickerLicensed"
    That one works, with gallery idMSO.

    Might be a little but tricky difference between Word and PowerPoint, as I can confirm, that arnelgp's 1.docx does work very well without the "Licensed" in the end of the control.id. ;-)

    Thank you both for your great effort in finding solutions. That is priceless, over and over again and I appreciate it very much.

Posting Permissions

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