Rubberduck
                                
                                
                                
                                    Rubberduck copied to clipboard
                            
                            
                            
                        Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
Sometimes an event handler signature can be typed manually: ````vb Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True Hide End If End...
Now that we can figure out what the member access is for bracketed member calls (see #2565), RD should have an inspection for use of bracketed calls on objects that...
When referencing a Type Library, VBA adds the properties and methods of any class declared as GlobalMultiUse to the global name space of the project. In Excel, that's how you're...
The *Search Results* toolwindow needs a way to copy a tab's contents to the clipboard.
It would be useful to be able to fully qualify types and/or members, for better clarity of types/identifiers and for ease of portability between projects. For example, moving a module...
Would it be possible to have a refactor option that allows moving a sub or function to a different module and updating the function calls to that procedure, such that...
Consider the following code: ``` Public Declare Function Foo Lib "foo.dll" Alias "FooW" (callback As LongPtr) As Long Private Sub FooCaller() Debug.Print Foo(AddressOf Bar) End Sub Private Function Bar() As...
Some CoClasses don't have public constructors, so VBA can't New 'em up. ``` Set myWorkbook = New Workbook With New Workbook Beep End With ``` The quickfix would require knowing...
The `VBA.Space/Space$` functions accept an argument `character`. If `character` is a `String`, then only the first character is used: ``` ?VBA.String(5,"Rubberduck") RRRRR ``` If the user provides an empty string,...
The `Range.Find` method has only one _required_ argument, but an additional 4 arguments default to the value used most previously by the _user_ (regardless of whether it is through VBA...