Rubberduck - ExcelUdfNameIsValidCellReference

Inspection type: CodeQualityIssues

Default severity: Warning

Reasoning

Another good reason to avoid numeric suffixes: if the function is meant to be used as a UDF in a cell formula, the worksheet cell by the same name takes precedence and gets the reference, and the function is never invoked.

This inspection will only run if the Excel library is referenced.

Quick-Fixes

The following quick-fixes are available for this inspection:

IgnoreOnce: Adds an '@Ignore annotation to ignore a specific inspection result. Applicable to all inspections whose results can be annotated in a module.
IgnoreInModule: Adds an '@IgnoreModule annotation to ignore a inspection results for a specific inspection inside a whole module. Applicable to all inspections whose results can be annotated in a module.
RenameDeclaration: Prompts for a new name, renames a declaration accordingly, and updates all usages.

Examples

Each example is a self-contained MCVE showing the feature in a single specific scenario.

Standard Module

Named Module1 by default, these are general-purpose standard procedural modules.

Class Module

Named Class1 by default, these modules define the default interface for an object of that type.

Predeclared Class

A class module with its VB_PredeclaredId attribute set to True (with or without a @PredeclaredId annotation).

Interface Module

Abstract interfaces are class modules (with or without an @Interface annotation) whose default interface is not a class type intended to be instantiated.

UserForm Module

A predeclared class with a design-time visual designer using the MSForms UI framework.

Document Module

Owned by the host application, these class modules belong to the host document and may handle various events fired by the host application.