PDA

View Full Version : Follow Up Question About the Ribbon



JKwan
11-06-2017, 10:00 AM
I was looking at this http://www.vbaexpress.com/forum/showthread.php?61244-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.

SamT
11-08-2017, 04:56 PM
Moderator bump

MINCUS1308
11-10-2017, 05:26 AM
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.

JKwan
11-10-2017, 07:16 AM
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

mdmackillop
11-10-2017, 08:06 AM
See if Ken Puls can assist (https://www.excelguru.ca/).

JKwan
11-10-2017, 08:19 AM
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.

mdmackillop
11-10-2017, 09:03 AM
He part wrote a book (https://www.excelguru.ca/list.php?category/84-Excel-User-Interface-Customization) on the ribbon. I would try posting in his forum

Paul_Hossler
11-13-2017, 08:00 AM
I don't think that BG color is controllable

https://msdn.microsoft.com/en-us/library/dd925058(v=office.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

JKwan
11-13-2017, 07:07 PM
1 - for curiosity
2 - cosmetics