This feature allows users to invoke the built-in functions of KUTOOLS using VBA code as follows: 1. Add a reference to KutoolsforExcel in the project (as shown in the following figure) Press Alt + F11 shortcuts to open the VB editor in Excel, and then please click Tools > References… to add KutoolsforExcele as a references in the VBA project. <img src="https://www.extendoffice.com/index.php?option=com_easydiscuss&controller=attachment&task=downloadAmazon&tmpl=component&id=760" alt="VBA-01.png" /> <img src="https://www.extendoffice.com/index.php?option=com_easydiscuss&controller=attachment&task=downloadAmazon&tmpl=component&id=761" alt="VBA-02.png" /> 2. Use the CallKutoolsAction method in a VBA code to call a specific function of KUTOOLS, which contains a parameter of the Actions enumeration type that specifies which function to specifically call, such as the following code: <pre class="line-numbers"><code class="language-VBA">Sub CallKutoolsActionDemo() 'Call the Compare Cells function Call Callkutoolsaction(CompareCells) 'Invoke the About function Call Callkutoolsaction(About) End Sub </code></pre>

KUTOOLS Le haghaidh EXCEL: Conas an fheidhm KUTOOLS a ghlaoch i script VBA?

By Excelfans Dé Luain, 28 Márta 2022

Freagraí 5

Is maith 1

tuairimí 15.1K

Vótaí 0

Ligeann an ghné seo d'úsáideoirí feidhmeanna ionsuite KUTOOLS a agairt ag baint úsáide as cód VBA mar seo a leanas:

1. Cuir tagairt do KutoolsforExcel sa tionscadal (mar a thaispeántar san fhigiúr seo a leanas)

Preas Alt + F11 aicearraí chun an eagarthóir VB a oscailt in Excel, agus ansin cliceáil le do thoil uirlisí > Tagairtí… a chur Kutools le haghaidh Excel mar thagairtí sa tionscadal VBA.

2. Bain úsáid as an CallKutoolsAction modh i gcód VBA chun feidhm shonrach KUTOOLS a ghlaoch, ina bhfuil paraiméadar den chineál áireamhachta Gníomhartha a shonraíonn cén fheidhm atá le glaoch go sonrach, mar shampla an cód seo a leanas:

Sub CallKutoolsActionDemo()

    'Call the Compare Cells function

    Call Callkutoolsaction(CompareCells)

    'Invoke the About function

    Call Callkutoolsaction(About)

End Sub