VBA Rubberducking

12:00 AM

RELOAD!

[Minesweeper] Games Played: 104, Bombs Used: 67, Moves Performed: 13876, New Users: 12

5 hours later…

4:37 AM

@MathieuGuindon / @M.Doerner are we OK to merge #5573 (light up COM project parsing)

Sure!

...but good to check with Max first

5:05 AM

where's the Compile menu in the VB6?

5:53 AM

Duck check: in a for loop does anyone else consider it taboo to modify the looping variable while it is executing? I just had the thought of raising an inspection result for this.

you would get a RTE

(I think at least - I remember getting it and it said the variable was locked but I can't remember if that was only for the For Each)

Past-Iven would modify it before he learned about the Step option. It feels wrong modifying it now.

Right now Tired-Iven heads to bed to properly rest. Night all.

6:57 AM

[rubberduck-vba/Rubberduck] MDoerner merged pull request #5573: Remove com project flag from bclothier/Rubberduck/RemoveComProjectFlag into rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] bclothier pushed commit 79f23f10 to next: Remove the conditional flag to put the loading of user project in use.

[rubberduck-vba/Rubberduck] bclothier pushed commit 2fa14f9e to next: Merge branch 'next' of github.com/rubberduck-vba/Rubberduck into RemoveComProjectFlag

[rubberduck-vba/Rubberduck] bclothier pushed commit 222730b5 to next: Fix incorrect check of IntPtr.Zero and check oInst as the xml-docs said to do...

[rubberduck-vba/Rubberduck] web-flow pushed commit 8695c05e to next

Merge pull request #5573 from bclothier/RemoveComProjectFlag

Remove com project flag

7:15 AM

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created draft prerelease Prerelease-v2.5.1.5559

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot prereleased draft prerelease Prerelease-v2.5.1.5559

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot published prerelease Prerelease-v2.5.1.5559

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created tag Prerelease-v2.5.1.5559

[rubberduck-vba/Rubberduck] build for commit 8695c05e on next: AppVeyor build succeeded

1 hour later…

8:18 AM

[rubberduck-vba/examples] OmarZini opened issue #6: Issues understanding the use of Interfaces in your Rubberduck website entry

> https://rubberduckvba.wordpress.com/2020/02/27/vba-classes-gateway-to-solid/

I'm still trying to get my head around this post and I certainly need some help here. I can't seem to properly understand the use of the Interface. Initially, the goal was not to expose some members of the class due to the fact that it could raise a run-time error, which we want to avoid (compile errors are preferred). When not exposing a procedure member like a function, the best way is to use an Interface. I get

3 hours later…

11:25 AM

@MathieuGuindon slightly OT comment on your answer here

> works nicely with static code analysis and refactoring tools, such as Rubberduck - full disclaimer, that's my website, and I manage the Rubberduck open-source project.

should be

> works nicely with static code analysis and refactoring tools, such as Rubberduck - full disclosure, that's my website, and I manage the Rubberduck open-source project.

Vogel612

@FreeMan you do know that you can suggest an edit?

You're disclosing your relationship to RD, not disclaiming knowledge or responsibility

I do, just wanted to be sure the difference was understood and not just make a quiet change.

I know there are many non-native English speakers here. My Mom was an English major and my Dad was just super picky about language, so I learned very "proper" English before being allowed to mess around and say it wrong.

My intent is to help teach, not poke fun at.

y'alls English is so much better than my French ever was or my German, Czech, Hungarian or anything else would ever hope to be...

@Vogel612 also: Done.

11:56 AM

@QuackExchange that's a bit of nightmare code written with a circa 1982 methodology. Frankly, that looks very much like some of the very first code I ever wrote!

@FreeMan I have to admit, I was reasonably decent at Hebrew after a 3-month, full-immersion, sink-or-swim experience. That was 36 years ago and haven't used it since, don't ask for a demonstration.

2 hours later…

1:32 PM

@MathieuGuindon Finally saw Omar's comments and replied. IDK why I couldn't see it until just this morning.

1:42 PM

[rubberduck-vba/Rubberduck] mgusovsky starred us

2:39 PM

@mansellan or @MathieuGuindon or whoever knows VB6 - where is the compile button supposed to be? I seem can't to find it. I can Make a project but it's annoying to do that everytime just to compile....

I am pretty sure it would normally be under the Project menu but nah....

BigBen

3:00 PM

@FreeMan can I have a demonstration? sorry couldn't resist

עִבְרִית‎

a smartaleck question deserves a smartaleck answer

I'm sure you would have so much fun typing that LTR.

> Microsoft Visual Basic
>
> License information for this component not found. You do not have an appropriate license to use this functionality in the design environment.

Great. Care to tell me which component I'm missing?

1 hour later…

4:24 PM

@FreeMan nice! thanks for the edit!

:thumbsup:

@this IIRC in VB6 the "Compile [ProjectName]" command is "Build [ProjectName]" and yeah, it builds the executable... like in VS?

there's no Build in the menus

the closest thing i have is Make [ProjectName] under the File menu

4:56 PM

Right, it was "make" back then =)

Anyone else getting error 459 trying to handle MSForms.Control events (e.g. Enter, Exit) on a dynamic (or not) textbox?

Looks like MS broke MSForms again

@MathieuGuindon so you can't compile without building?

5:19 PM

@mansellan Belated but IMO, my biggest fear is that if we emphasize too much on the "minimum", we might end up with a nugget 1.0 that is so broken and cannot go any further forward that the nugget 2.0 has to be a restart, which would massively annoy the audience.

mansellan

5:41 PM

@this yep good point. guess its finding the right balance

and yeah, it's "Make" in VB6... I guess they thought "Compile" sounded too scary!

Make is annoying because there's a dialog (uh-oh!) and it's trying to make an .exe while all I wanted to do is just compile to verify for errors. I swear there was a separate Compile menu somewhere....

6:04 PM

@this vb6.exe can take CLI args to build a .exe/.dll with a build script (implemented that at my VB6 gig back then, was very nice!)

Right but I just want to check for compile error?

then you need to compile =)

...or have RD tell you something is amiss?

6:20 PM

But the point is that I can't find the Compile button in the menus. I can only Make

I am sure it was under the Project but it's not there. Nor under Debug menu

mansellan

6:32 PM

I don't recall ever seeing one

pls don't gaslight me, bro

dons tinfoil hat

mansellan

rofl

6:46 PM

remembered that menus could be customized so looked through the customize, and indeed, I did find a Start with full compile under Run menu. But no Compile button.... feel so weird.

also unsure why the Run doesn't show normally even though the project is an exe

1 hour later…

8:19 PM

How do you wean people off the dependency of visualizing things in an Excel grid?

I'm trying to avoid the problems that come about because of having them in a range/table because of sort order.

TLDR the information is filtered based on criteria. If there are any visual cells left after filtering I'd want to go with the first result.

Best solution I can think of is to sort in the order I need every time.

not sure what the problem is being solved - why can't they sort whtaever they want?

If someone sorts the data in the table according to how they want to view it then I can't ensure it would return the data I'd need in the order I'm expecting it too for when I filter.

Although thinking about it a little more filtering should only be a problem the first time I do it. Thereafter even if calls are redundant they shouldn't affect performance since it's already sorted.

I may be #PrematurelyOptimizing. Worst case I can fix it when it's too slow.

still not sure I understand why that is a problem. The solution shouldn't depend on a particular sort.

I'm grabbing the first visible row in the table as the result I want. I'm expecting the order to be sorted by - Col12 Asc, Col1 Asc, Col2 Asc.

If it's sorted in - Col12 Desc, Col1 Asc, Col2 Asc or any other order I can't guarantee the result I want will be in the first visible row.

Going along the lines of "You can't trust user input. Must validate everything beforehand."

9:13 PM

but... why?

Decision makers want to see a table of options used in the decision making process.

It permits them filter the options to ultimately see the valid results.

i guess my confusion was because the calculations should not depend on how the layout is sorted