Public Sub FindMenuCommand(ByVal caption As String)
Dim cmd As CommandBar
Dim ctl As CommandBarControl
For Each cmd In Application.VBE.CommandBars
For Each ctl In cmd.Controls
If ctl.caption = caption Then
Debug.Print "Found '" & caption & "' at CommandBar '" & cmd.Name & "', index " & cmd.Index & "; control #" & ctl.Index & "."
End If
Next
Next
End Sub
ThisWorkbook.FindMenuCommand "Last Positio&n"
Found 'Last Positio&n' at CommandBar 'Code Window', index 9; control #13.
so the code window's context menu is the "Code Window" commandbar, index 9.
@RubberDuck I think we should release 1.3 as soon as SC is completed - I'll work on cleaning up in the meantime, instead of adding other features. The Declarations API needs to replace tree listeners just about everywhere. That should speed up a number of inspections...
Refactor/extract-method desperately wants to use that API too
We might also want "Source Control" > "Undo" / "Commit" buttons in the code explorer context menu
> Now, I see you shaking your heads, thinking “Well, some Dutch do this, but NOT all of us!” Well folks, this year it is estimated that nearly 4 million Dutch people will pack up their tents and take the highly exotic camping vacation described above. That is a hell of a lot of caravans —and trust me, the local Dutch Albert Heijn’s will be busy before they leave!
> Well technically it does. The issue is that the token we intend to rename sometimes only span a single character. This has been observed especially on parameter declarations (parameter usages seem to work as expected) - consider the below code, where | represents the position of the caret on the foo parameter: Public Sub DoSomething(ByRef fo|o As String) foo = "abc" End Sub The rename refactoring will prompt for a new name for the DoSomething procedure. However in this case: Public...
Sub DoSomething(ByRef foo As String) fo|o = "abc" End Sub The rename refactoring will prompt for a new name for the foo parameter. This is annoying. Not a major issue, but annoying. The same behavior has been observed with Const declarations (usages work fine, local variable declarations work fine too). The glitch is not with the rename refactoring code - further investigation is needed to determine if it's with the tokens in the ANTLR syntax tree, or somewhere between the token and...
the Selection struct that's created out of the token's position and length; fixing this issue may also fix an issue with navigation not always making a selection that matches what the IDE is displaying (can't find the issue#, not sure it's documented).
> The DeclarationType enum doesn't have a Project member; identifiers referring to a VBProject are currently being ignored. This needs to be changed so that the rename refactoring can be used to rename a project and all its explicit references in a VBA code base.
hmm... looking at the #vsAssign grammar rule, which is the only place the ASSIGN (:=) operator token is used in the grammar.... I'm not sure named parameters are correctly picked up by the parser at all....
oooh valueStmt is recursive... it works!!
now, how do I get the procedure's name from the procedure call statement's valueStmt
#ParsingIsHard
ah, got it.
refactor/rename will work with named parameters by the end of the day!
> Should be able to "Publish" and "Delete" from a right click context menu. "Publish" should only be enabled for Unpublished branches. Delete should ask for confirmation.
Which characters are illegal within a branch name?
VBA Rubberducking
VBA Rubberducking