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>
I did get these to show up in the QAT (whew!) but the macros still don't work.
They still throw the same useless error.