在Excel VBA中搜索功能使用 [英] Searching for function usage in Excel VBA

问题描述

我已经继承了一个具有许多VBA功能的Excel电子表格，并不清楚它们中的大部分（甚至是）在哪里使用。

有没有办法找到VBA函数的用法，或者可以搜索它的调用，类似于您可以单击一个函数/方法的方法标准IDE并在整个代码库中找到它的用法？

解决方案 div>

在VBA中 - 使用CTRL + F，然后选择当前项目，查找项目中函数名称的每个用法。

工作表 - 使用CTRL + F，并确保查看设置为公式。然后单击查找全部以查找工作表中功能名称的每个用法。

I have inherited an Excel spreadsheet with many VBA functions and it's not clear where (or even if) a lot of them are being used.

Is there a way to find the usage of a VBA function, or perhaps search for invocations of it, similar to the way you can click on a function/method in a standard IDE and find its usage throughout the codebase? I am looking for the cells from which the functions could be being called, not invocations from within other VBA functions.

解决方案

In VBA - Use CTRL+F and select "Current Project" to find each usage of the function name in the project.

On Worksheet - Use CTRL+F and make sure "Look In" is set to "Formulas." Then click "Find All" to find each usage of the function name in the worksheet.

这篇关于在Excel VBA中搜索功能使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！