Rubberduck
Rubberduck copied to clipboard
Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
The grammar doesn't enforce maximum identifier lengths (see #2855), yet we assume that no parser error means the code is compilable. We need an error-level inspection result to pop for...
Some inspections are module level, but others are specific to members of a module. Inspection Results' Location column should be more specific about the location by including the location's member...
https://msdn.microsoft.com/en-us/library/office/gg278477.aspx > The `LayoutEffect` property is read-only and is available only in the `Layout` event. The `Layout` event is only fired for the following controls: - Frame/Frame2 - MultiPage/MultiPage2 -...
A *language opportunity* inspection: ````vb Dim something As Object Set something = New Object With something .Foo = 42 Debug.Print .Bar End With ```` If a local variable is only...
For example: `Excel.Application.HinstancePtr` should be preferred over `Excel.Application.Hinstance`
OK, I'll say it. There is no good use case for these. This... ``` Static Sub Foo() Dim bar As Long bar = bar + 1 Debug.Print bar End Sub...
While typing some code, I inadvertently made the following typo while copying and pasting. ```vb If Right$(prp.Name "EmMacro", 7) Then ``` When I meant to type: ```vb If Right$(prp.Name,7) "EmMacro"...
If a variable's first assignment (taking code paths into account) is a literal with the default value for that variable's declared type, Rubberduck should suggest removing that redundant assignment. ````vb...
When executing the following procedure, in modules declared with different `Option Compare` statements, the user will get different results: ```vb Sub test() Debug.Print InStr(1, "abc", "ABC") End Sub ``` There...
https://msdn.microsoft.com/en-us/library/aa241733(v=vs.60).aspx > The object is created the first time the variable is used in code. This incurs a slight increase in overhead on **each** function call. > [The instance] incurs...