View Single Post
 
Old 10-31-2016, 10:38 AM
MAtkins MAtkins is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2016
Posts: 13
MAtkins is on a distinguished road
Default

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.
Reply With Quote