Skip to main content
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, March 28, 2022
  6 Replies
  20K Visits
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 Compare Cells function
Call Callkutoolsaction(CompareCells)
'Invoke the About function
Call Callkutoolsaction(About)
End Sub
2 years ago
·
#2622
I Just love your Blog super interesting and informative.
2 years ago
·
#2793
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 :) )
2 years ago
·
#2796
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.:)
1 year ago
·
#3475
yes kutools are not available for word
2 weeks ago
·
#8738
Can we add barcodes with vba? I have been able to get the barcode window to open with call CallKutoolsAction(insertbarcode)

but i want the vba code to input the data rather than add it manually as I have multiple barcodes to add.
2 weeks ago
·
#8742
Can we add barcodes with vba? I have been able to get the barcode window to open with call CallKutoolsAction(insertbarcode)

but i want the vba code to input the data rather than add it manually as I have multiple barcodes to add.
Hi there,

Thank you for your question! Kutools supports calling its features through VBA, such as opening the barcode window with CallKutoolsAction(insertbarcode). However, it does not currently support using VBA to input data directly into the barcode feature. Let us know if you have any other questions!

Amanda
  • Page :
  • 1
There are no replies made for this post yet.