vba VBE无法识别UCase,需要什么参考?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/13719687/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 18:42:55  来源:igfitidea点击:

UCase not being recognised in VBE, what reference is needed?

excelvba

提问by mezamorphic

I am going through some vba code and I get a compile error on UCase(). It says compile error: can't find project or library. I have never encountered this before, what library do I need to add through references to recognise this?

我正在查看一些 vba 代码,但在 UCase() 上出现编译错误。它说编译错误:找不到项目或库。我以前从未遇到过这种情况,我需要通过引用添加什么库来识别这一点?

回答by barrowc

Check the References dialog and you should find at least one reference marked "MISSING:" Remove that missing reference and all should be well.

检查“引用”对话框,您应该至少找到一个标记为“缺少:”的引用,删除缺失的引用,一切都会正常。

Missing references can cause VBA to act strangely including not recognising built-in keywords

缺少引用会导致 VBA 行为异常,包括无法识别内置关键字

回答by Axel

If not already included you should add

如果尚未包含,则应添加

Tools -> References - > "OLE Automation"

That ist the library where UCase is available.

那就是 UCase 可用的库。