![]() |
#3
|
|||
|
|||
![]()
I still can't find a way to get custom icons on the QAT that call VBA macros.
I've been developing Microsoft code since 1994 and am certified in Visual Basic 5.0. I did finally get a tab to show up in the ribbon with my icons loaded but they don't work. I'm getting an error saying: 'Wrong number of arguments or invalid property assignment'. The 'macros' are simply VBA public scoped Sub procedures that put the cursor on a specific line in the doc depending on which 'macro' was called. The procs don't have arguments and no properties are changed. I should state that they run if I pull them up in the Developer tab or hit the shortcut key to them. I also had them on the QAT with a stock icon. The macros run just fine. Before I attempt to get these into the QAT, how do I make these VBA macros run? Code:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="RibbonControl.Onload"> <ribbon> <tabs> <tab id="TabNav1" label="Inspectagator Sections" > <group id="customGroup" label="Custom Group"> <button id="btngoToRoofing" label="Roofing" image="icoRF" onAction="goToRoofing"/> <button id="btngoToExterior" label="Exterior" image="icoEX" onAction="goToExterior"/> <button id="btngoToGarage" label="Garage" image="icoGG" onAction="goToGarage"/> <button id="btngoToPlumbing" label="Plumbing" image="icoPL" onAction="goToPlumbing"/> <button id="btngoToAttic" label="Attic" image="icoAT" onAction="goToAttic"/> <button id="btngoToElectrical" label="Electrical" image="icoEL" onAction="goToElectrical"/> <button id="btngoToMechanical" label="Mechanical" image="icoME" onAction="goToMechanical"/> <button id="btngoToKitchen" label="Kitchen" image="icoKI" onAction="goToKitchen"/> <button id="btngoToInterior" label="Interior" image="icoIN" onAction="goToInterior"/> <button id="btngoToBedrooms" label="Bedrooms" image="icoBD" onAction="goToBedrooms"/> <button id="btngoToBathrooms" label="Bathrooms" image="icoBT" onAction="goToBathrooms"/> <button id="btngoToPool" label="Pool" image="icoPO" onAction="goToPool"/> </group> </tab> </tabs> </ribbon> </customUI> They still throw the same useless error. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
stubbo66 | Visio | 2 | 08-24-2016 05:58 PM |
![]() |
topdog | Outlook | 6 | 04-19-2016 11:39 AM |
Master slide placeholder text - make completely custom for each layout | lhulmef | PowerPoint | 1 | 03-25-2015 03:03 PM |
![]() |
WaltR | Word | 1 | 04-09-2012 11:42 AM |
outlook 2003 custom email rule icons | pgasparr | Outlook | 0 | 06-29-2011 06:16 AM |