VBA Rubberducking

That way reviewers don't pick on stupid things like indentation and naming. The way to get a great review is to get it so spotless that people have to address what the code does, not what it looks like.

@vba4all wait, you're @mehow?

noticed that answer was all lonely and missing a checkmark

I just got access to the SO low quality queue.... It's scary in there.

And VBA needs unambiguous bitwise operators

I've been doing it several years and know not how most stuff works

> I've been doing VBA for about 2 months, I know how most stuff works.

Eh, I will just give them more reasons to hate VBA

IteratableSet

MySet

It's a set..... ugh...... ummmm...........

@RubberDuck except when it's LinqEnumerable.Select(Delegate) ;)

Everytime someone uses .Select in vba Santa kills a puppy.

> My code is so bad that I should fell bad about it? jk (I already know its bad)

that upgrade isn't coming soon enough

MZ-Tools: deprecated

the cherry on top would be a "Post on Code Review" button, with a feature that implements Simon's CR post builder, for VBA.

select the 3rd nested If..Else block in a procedure, right-click, "Refactor", "Extract Method", a dialog pops up; enter new method name, verify parameters (automagically detected already) and return type (also automagically detected) and procedure kind (guess what, automagically detected also), click Ok ~> done.

I'd really want to think of it as some "ReSharper for VBA"

oh wait, it's actually about encoding

and yeah, it's a "what's this veelookup?" user ;)

@enderland that Workplace.SE answer of yours was awesome... almost made me create an account there ;)

so that's why I started backing off questions that are too broad to start off with...

I'm redesigning the DeclarationSyntax, I had it wrong. I need to consider it as a "HasChildNodes" syntax - so Dim a, b, c can produce a DeclarationNode with 3 child VariableNode nodes.

now one too many in the Const regex.. I think I'm starting to regret using regex.

you need a panel

@RubberDuck if you make an options window/dialog, make it have tabs, or another mechanism for having "pages" - the refactorings will need options too, and perhaps the test module/method templates can be configurable too.

REVERT REVERT!!!

> Probably, but you're annoying now, I bet you haven't upvoted my answer as of yet, and I have work to do. Google it.

actually the VBE add-in, featuring an automagic unit testing functionality

wow, first SO checkmark in.... ages!

can't imagine that in a real life situation .. like on humans haha

found something... circullar reference in the database

and good grief give it a better name........

closes connection and breaks calling code

passes an ADODB connection to Mat

@vba4all reboot! reboot! reboot!

@enderland I don't see a use for such code... even if it worked. If you have an Outlook.Application instance declared WithEvents I suppose you could.... .... ....

@ticker easy: uninstall damn annoying stupid plugin

not everything cause structs are technically not really objects..

(there's no concept of a default property in C#)

That's a good point. But I honestly don't mind debugging broken code when I'm getting paid to do it.

> Retailcoder's answer as a general approach is top notch.

If only there was an actually-worth-reading tag

If only stars resulted in rep. =)