在Excel宏中定位函数 [英] Locating Functions within Excel Macros

问题描述

我正在使用Excel宏通过ThreeDify加载项创建4D图形.记录宏时，它不会拾取我使用外接程序执行的任何命令.我可以编辑代码，但是找不到将数据插入到graph/ThreeDify中的命令.有没有一种方法可以从Excel查找或查看加载项公式?

I'm using an Excel Macro to create a 4D graph with the ThreeDify Add-In. When I record the Macro, it doesn't pick up any command I perform using the Add-in. I can go in and edit the code, but I can't find commands that will insert my data into the graph/ThreeDify. Is there a way to locate or view the Add-In formulas from Excel?

推荐答案

您应该能够在VB编辑器的对象浏览器中查看所有可用的功能.

you should be able to see all the functions that are available to you in the Object Browser in the VB Editor.

在VB编辑器中，按 F2 键，然后在顶部的下拉菜单中选择AddIn VBA Project，然后将在左侧的列表框中列出类/模块，当您单击每个按钮时，您会看到(公共)功能或过程.

In the VB Editor, strike the F2 key, then select the AddIn VBA Project in the drop-down at tyhe top, then the classes/modules will be listed in the listbox on the left, and when you click on each one you can see the (public) functions or procedures.

这是一张图片:

这篇关于在Excel宏中定位函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！