Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
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!