Background
I am working on a VBA paradigm for modifying the Excel environment from a UDF. I call this "sudo mode", and I leverage Application.Run() to invoke a delegate procedure, like RunSudo() in my example.
' Delegate to sudo mode.
...
Application.Run GetSudoCall()
' ^^^^^^^^^^...
Got the declarations section to fold at the last statement (or comment) before the first member, and the first member's fold to include top-of-procedure contiguous comment lines
Only the top-of-procedure comments for the rest of a module remain weird
Hm, actually top-of-procedure comments should not be folding along with the procedure, but contiguous comment lines should be foldable
Meh, got other priorities; moving on to block completion.
also, there's exactly zero difference between a 10-liner module and a 700-liner module, and most of the delay with 1300 lines feels like it's still the idle timer. 2600 lines feels the same, 5100 lines too, ..I'm at 10.2K lines and it's still sub-second to parse, fold, and syntax-highlight.
2
VBE won't take more than 10K lines, so I'll stop here :)
@MathieuGuindon yeah ok... when the parser doesn't choke on a conditional compilation directive at line 346 and actually goes to line 9999, it does take a noticeable while... but the editor doesn't freeze or anything, so it's like "oh well, it'll catch up soon enough"
for a small module it's just ridiculous
but... 5 seconds is way too long to wait for block completion
okay, so we're sub-second up to ~1350 lines.
...but that's with the LL prediction mode
SLL handles 10K lines eyes closed
lol SLL parses a small module faster than you can physically bat an eyelid
so, block completion can work off SLL
(even as it ends up requiring 2 passes)
actually, the editor parser could work off its own simplified grammar - it doesn't need to know everything about procedure bodies, just a handful of specific foldable code blocks
got sidetracked with code completion.. it's going to be fun to implement once we have the full parser up. for now there's just a method that can show the completion popup given a bunch of ICompletionData items
Background
I am working on a VBA paradigm for modifying the Excel environment from a UDF. I call this "sudo mode", and I leverage Application.Run() to invoke a delegate procedure, like RunSudo() in my example.
' Delegate to sudo mode.
...
Application.Run GetSudoCall()
' ^^^^^^^^^^...
VBA Rubberducking
VBA Rubberducking