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.
Printable View
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
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.
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).Code:<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
See if Ken Puls can assist.
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
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
1 - for curiosity
2 - cosmetics