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.
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.
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
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
Mincus, thank you for having an interests with my question.
Basically, I created an Editbox / Textbox in the Ribbon with XML code
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).<editBox id="editFindCaseNumber" imageMso="CalendarViewZoom" label="Find Synergi Case #" screentip="Find Synergi Case Number" showImage="true" onChange="editFindCaseNumber_onChange" getText="editFindCaseNumber_getText"/>
I attached an example file with the Editbox control in the Ribbon
Last edited by JKwan; 11-10-2017 at 07:31 AM.
See if Ken Puls can assist.
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'
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.
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'
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
1 - for curiosity
2 - cosmetics