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.
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.