Note: The other languages of the website are Google-translated. Back to English
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, 28 March 2022
  3 Replies
  3.9K Visits
0
Votes
Undo
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.

VBA-01.png
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:


Sub CallKutoolsActionDemo()
'Call the Cpmpare Cells function
Call Callkutoolsaction(CompareCells)
'Invoke the About function
Call Callkutoolsaction(About)
End Sub
3 months ago
·
#2622
0
Votes
Undo
I Just love your Blog super interesting and informative.
1 month ago
·
#2793
0
Votes
Undo
Hi,
I am trying to add Kutools for Word the same way, but in tools - references I miss "KutoolsforWord", can you help me out please? (Off course I have it installed :) )
1 month ago
·
#2796
0
Votes
Undo
Hi,
I am trying to add Kutools for Word the same way, but in tools - references I miss "KutoolsforWord", can you help me out please? (Off course I have it installed :) )


Sorry, we don't have it in the Kutools for Word.:)
  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!