RELOAD!

[bruglesco/fleet-command] 1 commit. 25 additions. 8 deletions.

[rubberduck-vba/Rubberduck] 29 commits. 13 opened issues. 7 closed issues. 14 issue comments. 239900 additions. 190956 deletions.

[Zomis/AdventOfCode] 2 commits. 1200 additions.

@this select the lines in the code file (have them in the url), then click the little ... button on the left, select "copy permalink"

Do we have any opinions on doing stuff like IStuff_DoIt() within a private procedure from a class that implements IStuff

smells, but that's more of a design/style thing

kind of similar to invoking a handler. at least it's private =)

yeah. I guess with so much boilerplate required, it makes it tempting to cut corners to avoid creating yet another private procedure just to handle the interface & internal use.

sad ducky

@this well, why not just have the interface implementation invoke the private stuff instead?

58% for "IDE is under-featured"

IOW if every VBA dev used RD, VBA could significantly reduce its dread..li...ness

@MathieuGuindon no it has its own implementation which calls the private procedure also.

[rubberduck-vba/Rubberduck] Vogel612 created comment on issue #4656: NRE in UnreachableCaseInspection

> closing this as duplicate of github.com/rubberduck-vba/Rubberduck/issues/4659

[rubberduck-vba/Rubberduck] Vogel612 closed issue #4656: NRE in UnreachableCaseInspection

[rubberduck-vba/Rubberduck] Vogel612 is checking what fun stuff @Duga can say about project cards

[rubberduck-vba/Rubberduck] Vogel612 added label duplicate to issue #4656: NRE in UnreachableCaseInspection

[rubberduck-vba/Rubberduck] Vogel612 added label regression to issue #4659: NRE in UnreachableCaseInspection

[rubberduck-vba/Rubberduck] Vogel612 created comment on issue #4659: NRE in UnreachableCaseInspection

> was previously reported under github.com/rubberduck-vba/Rubberduck/issues/4258

time for me to hit the hay. somewhat more on my usual schedule :D

@Vogel612 'night!

[rubberduck-vba/Rubberduck] comintern synchronized pull request #4650: Locked references removal fix

Gah... Why didn't that pull the rest of that commit?

[rubberduck-vba/Rubberduck] comintern assigned comintern to issue #4651: Add/Remove References delay

[rubberduck-vba/Rubberduck] build for commit 35949d66 on unknown branch: AppVeyor build failed

BUILD FAILURE!

[rubberduck-vba/Rubberduck] comintern synchronized pull request #4650: Locked references removal fix

@Duga I think you need the reset of cursor in a finally block

Wrap the whole thing in a try? Not a bad idea.

Yeah. Don't want them stuck with forever waiting cursor if something goes wrong there. ;)

I'll catch that in a sec. Might as well wait for AV to finish.

Pond report: :+1: for no pain. Don't feel like doing anything requiring thinking though...

:thumbs-up:

@IvenBach squirrelized much?

As in swelling/chubby cheeks? None at all.

wow

I'm still as dead sexy fugly as ever.

lol

Just bored.

I would love to be bored. I need to take about a month off work...

I would like work to be assigned. We're on opposite ends of the work spectrum.

@IvenBach I can go through a number of issues and assign them to you if you want =)

Downloading PoE update.

PoE?

Path of Exile.

ah

You figure out my build issues on work box and I'll be able to work on RD at work.

Nuke it again?

got teamviewer at work?

[rubberduck-vba/Rubberduck] build for commit d30fc88b on unknown branch: AppVeyor build succeeded

Yeah. But I'm not willing to ask nor have IT ask who's connecting.

[rubberduck-vba/Rubberduck] comintern created comment on issue #4647: Add/Remove References Dialog isn't wide enough. AKA "Werez mah buttunz!"

> It wouldn't seem like it, but a ListView is absurd difficult to keep the column sizes in sync with a sizeable container without switching the item display container to a GridView (which only makes it merely difficult). The problem with using a GridView for this IMHO is that it is thermonuclear overkill for what it would be doing, and even then the process of keeping everything aligned at the correct column sizes is expensive as hell in terms of processing. Granted, there aren't a ton of re

@Duga That's the stuff.

[rubberduck-vba/Rubberduck] comintern synchronized pull request #4650: Locked references removal fix

@Duga @Comintern that works perfectly

Cool. On the way.

[rubberduck-vba/Rubberduck] comintern assigned comintern to issue #4647: Add/Remove References Dialog isn't wide enough. AKA "Werez mah buttunz!"

Hey do the arrow buttons and other icons in the listviews have tooltips?

No, but they easily could.

@IvenBach you could daisy chain; work to home, then to one of us.

Thus if they ask you were remoting from home

Doesn't it just connect to the TeamViewer server?

@this Hadn't thought of that...

@MathieuGuindon prolly but they might be tracking who is on the meeting or remote control, IDK.

[rubberduck-vba/Rubberduck] build for commit c4524c7e on unknown branch: AppVeyor build succeeded

Woah, this is cool AF. If you "peek definition" on something R# can decompile, it shows you the decompiled source.

// Decompiled with JetBrains decompiler
// Type: System.Windows.UIElement
// Assembly: PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
// MVID: 2C71DFD2-6DA6-4692-B62C-BFBBF566AF53
// Assembly location: C:\Windows\Microsoft.NET\assembly\GAC_32\PresentationCore\v4.0_4.0.0.0__31bf3856ad364e35\PresentationCore.dll

@this I like your upper hand in handling of the green hat. :)

[rubberduck-vba/Rubberduck] comintern synchronized pull request #4650: Locked references removal fix

[rubberduck-vba/Rubberduck] build for commit 8d1cbada on unknown branch: AppVeyor build succeeded

@IvenBach Careful. It tends to eat your time. ;)

(Though I think it's one of the better things to do after having one's wisdom quartered.)

[rubberduck-vba/Rubberduck] MDoerner synchronized pull request #4648: Better member annotation scoping

[rubberduck-vba/Rubberduck] build for commit 53568951 on unknown branch: AppVeyor build succeeded

Is there a way to make VS use that actual case of the path when adding new icons to resources?

On another note, I just ran dotMemory on RD and we definitely have some common WPF memory leaks. However, I am not sure how much unmanaged memory is attached to them.

Still, we should probably fix them.

The most prominent one is that we bind to DeclarationInspectionResult.Inspection not in one time mode.

That property does not implement INotifyPropertyChanged.

So, we should either wrap it in a view model or bind in one time mode.

I cannot imagine the inspection on a result to ever change.

@M.Doerner did it identify the two convertors leaking memory streams as candidates?

[rubberduck-vba/Rubberduck] Inarion created comment on issue #4654: "Find all references" gives an error for References

[rubberduck-vba/Rubberduck] retailcoder closed issue #4649: "Add/Remove Reference" dialogue allows removal of locked references. Sorta...

[rubberduck-vba/Rubberduck] retailcoder merged pull request #4650: Locked references removal fix from comintern/Rubberduck/refs into rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] retailcoder closed issue #4334: RD startup error when multiple new Excel projects are open before launch

[rubberduck-vba/Rubberduck] retailcoder closed issue #4651: Add/Remove References delay

[rubberduck-vba/Rubberduck] retailcoder did something with some project card

[rubberduck-vba/Rubberduck] retailcoder closed issue #4647: Add/Remove References Dialog isn't wide enough. AKA "Werez mah buttunz!"

[rubberduck-vba/Rubberduck] mansellan created comment on issue #4477: Code Explorer - Option to have module show up in multiple places (Feature request)

> #4478 and #4506 cover the items discussed above - closing this.

[rubberduck-vba/Rubberduck] mansellan closed issue #4477: Code Explorer - Option to have module show up in multiple places (Feature request)

[rubberduck-vba/Rubberduck] mansellan added label status-declined to issue #4477: Code Explorer - Option to have module show up in multiple places (Feature request)

@this No, that is not what it was looking for.

We have a ton of bitmaps that do not get disposed, though. (dotMemory told me that their finalize ran.)

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

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

[rubberduck-vba/Rubberduck] build for commit 4213a8ae on next: AppVeyor build succeeded

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.Parsing/Annotations/IdentifierAnnotationService.cs of pull request #4648: Better member annotation scoping

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.CodeAnalysis/Inspections/Abstract/InspectionBase.cs of pull request #4648: Better member annotation scoping

@M.Doerner Ok so the issue I opened may still be relevant, then.

[rubberduck-vba/Rubberduck] daFreeMan created comment on issue #4647: Add/Remove References Dialog isn't wide enough. AKA "Werez mah buttunz!"

@Duga @FreeMan but think how much more calories you could burn with extra wrist exercises!

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.CodeAnalysis/Inspections/Abstract/InspectionBase.cs of pull request #4648: Better member annotation scoping

@Duga @Duga @FreeMan Wouldn't you prefer to just be able to drag and drop it?

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Parsing/Annotations/IdentifierAnnotationService.cs of pull request #4648: Better member annotation scoping

@this no comment

@Comintern That could work. Is that implemented but not obvious?

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.CodeAnalysis/Inspections/Abstract/InspectionBase.cs of pull request #4648: Better member annotation scoping

@FreeMan Not implemented yet, but on the agenda.

Cool!! ^

@Comintern eeeexcellent...

Now, how many reporting OOM/memory usage issues will notice that?

Hopefully all of them.

All those including RAM or Batman in the title of their issue

no wait, similar issues is smarter than that, is it?

As a frequenter of the issues log, I went to my already open tab and clicked on the code tab to go DL the newest build. As the page was reloading, the brain said "Hey, something looked... different..." and I had to go back to see it.

@MathieuGuindon that's a different feature. The pinned issue is before you get to create an issue.

Yeah just saw that - awesome!

(not sure if you can get to create an issue without going via the issues page).

not sure who pinned it, though.

You can if you type the url or follow a link to /issues/new

You can if you're looking at an existing issue and click the new issue page. You can get to an existing issue from any shared link.

Like, that big green 'report an issue' button in the about box, IIRC

yeah obviously for the type-in. Not sure if we have a link to /issues/new somewhere else, though.

I just wish you could personally pin an issue without self assigning it. Seems to only be a global option.

@FreeMan Ah, yes, that would be a likely candidate.

@MathieuGuindon potential source...

But hopefully the similar issue feature will help dissuade that.

Hmm. I wonder.

I think this feature needs more work. Note that none of 3 variants lists any open issues.

Especially considering that the issue does have this in the OP:

> After observing random "System resources exceeded" or "Out of memory" with my usercode which didn't quite make sense, I later ran quick fixes. After applying changes, I went to start the application and immediately got the System resources exceeded *despite have NOT run any VBA code`.

Pretty sure "batman" finds it :-)

Yeah, it does. It looks like it's limited to the subject, not the contents.

which kind of hamper its usefulness; you can count on users to come up with a zillion synonyms for same thing. :\

@this it needs to sort by open/closed status I think. Not sure what the sort is, but open matches should show up before closed ones imo

[rubberduck-vba/Rubberduck] bclothier edited issue #3347: Holy RAM, batman! (Out of memory errors and excessively high memory usage)

It does, when you search on the RAM

::+1:

derp

that's weird. I swear for a instance, the open issue was listed 2nd. but by then I took the screenshot, it's now on 1st.

I wonder if it sorts pinned issues to the top if they match.

@TweetingDuck Never thought of that! :( At one point, I had 2 HUGE rack mount Cisco switches that a friend of mine's company was disposing. He couldn't technically give them to me, but he did tell me when they were carefully placed next to the dumpster and we conveniently had to meet at his office after hours. I was going to use them at home (because everyone needs about 150 ports of 10/100 at home), but they just sat outside & rusted for about 10 years until I finally tossed them.

Found my morning bug.

@Duga nice!

@this I'm pretty sure I've seen closed issues above open ones

@FreeMan if it doesn't re-sort, then yeah that'd definitely be something that GH should improve.

@this so, is GH hosted on GH? If so, you should go open an issue.

@Comintern a star for you!

[rubberduck-vba/Rubberduck] comintern created pull request #4661: Make Add/Remove References match target project by ID, not name. to merge comintern/Rubberduck/refs into rubberduck-vba/Rubberduck/next

> This was throwing the the DeclarationFinder if multiple projects with the same name were open, meaning the dialog wouldn't show. Didn't notice this before when it was tied to the CE declarations.

...and fixed my morning bug.

@FreeMan I submitted the feedback already

@FreeMan Not entirely sure that's warranted in that it was literally my bug.

(and everyone else should, too)

Is there a way to clear all bookmarks in all files except the active one in VS?

@Comintern and another star for you!!

[rubberduck-vba/Rubberduck] Vogel612 milestoned issue #4334: RD startup error when multiple new Excel projects are open before launch

@Comintern for cleaning up after yourself

LOL

[rubberduck-vba/Rubberduck] Vogel612 milestoned issue #4649: "Add/Remove Reference" dialogue allows removal of locked references. Sorta...

[rubberduck-vba/Rubberduck] Vogel612 is checking what fun stuff @Duga can say about project cards

[rubberduck-vba/Rubberduck] Vogel612 created project card

@Comintern doing better than my kids. >:(

[rubberduck-vba/Rubberduck] build for commit bae177d8 on unknown branch: AppVeyor build failed

BUILD FAILURE!

[rubberduck-vba/Rubberduck] Vogel612 project card. Enough said.

Wut?

@Duga are you going to ever to say anything more than some snide remarks about project cards?

[rubberduck-vba/Rubberduck] Vogel612 moved project card

@Comintern cleaning up after yourself.

[rubberduck-vba/Rubberduck] Vogel612 is bored so why not move a project card

Oh damnit. That has to merge with the CE stuff.

Well OK, then.

"kid" (22 yo) dumped her coat on the floor then gave me lip about how hard it is to hang it in the coat closet. Didn't have much to say after pointing out that I put my coat in there every. single. day.

[rubberduck-vba/Rubberduck] Vogel612 project card. Enough said.

[rubberduck-vba/Rubberduck] Vogel612 is playing around with a project card

better, but...

can it dynamically size itself up to some sort of maximum?

[rubberduck-vba/Rubberduck] comintern synchronized pull request #4661: Make Add/Remove References match target project by ID, not name.

[rubberduck-vba/Rubberduck] build for commit 5b624a44 on unknown branch: AppVeyor was unable to build non-mergeable pull request

I mean, I'm running 1900x1200, there's space for it to grow.

BUILD FAILURE!

but I realize that not everyone's monitor is that big.

[rubberduck-vba/Rubberduck] comintern edited pull request #4661: Code Explorer Extreme Makeover (for some values of extreme)

@this thanks for asking. I was worried about offending her and making her go run off and hide...

What are "project cards" anyway?

it's all those cards in the Projects

I assume Vogel has been working mainly with 2 projects:

github.com/rubberduck-vba/Rubberduck/projects/19

and github.com/rubberduck-vba/Rubberduck/projects/13

note that whenever you add a issue to a project (or closed an issue that's already on a project), Duga gives you that "is bored so why not move a project card" remark.

it's a bit annoying that the automation doesn't seem to correctly handle adding already closed issues to the project...

@this ah!

[rubberduck-vba/Rubberduck] comintern added label PR-Status: WIP to pull request #4661: Code Explorer Extreme Makeover (for some values of extreme)

[rubberduck-vba/Rubberduck] comintern edited pull request #4661: Code Explorer Extreme Makeover (for some values of extreme)

[rubberduck-vba/Rubberduck] daFreeMan opened issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] daFreeMan created comment on issue #4662: Add/Remove references dialog box isn't wide enough

> An alternative fix would be to have the box remember its size so each user could customize it as (s)he sees fit and we would honor that request.

[rubberduck-vba/Rubberduck] Vogel612 added label enhancement to issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] Vogel612 added label up-for-grabs to issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] Vogel612 added label difficulty-01-duckling to issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] Vogel612 added label user-interface to issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] Vogel612 added label good first issue to issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] Vogel612 added label wpf to issue #4662: Add/Remove references dialog box isn't wide enough

yikes!

What's the magic incantation to make this work?

I have "smart-concatenation" and "Concatenate 'vbNewLine'" enabled:

jack up max lines to, say, 20

But no key combination seems to get me a ` & _` at the end of my bar =... line:

Public Sub foo()
  Dim bar As String
  bar = "text "
End Sub

is that it? just that it defaults to 2?

I've set it to 20 and hit Ctrl-Enter and it just stares at me...

nothing obvious (to me) in the log (starting with closing the Settings dialogue):

2018-12-19 09:50:08.6282;DEBUG-2.3.1.4340;Rubberduck.UI.Command.MenuItems.ParentMenus.ParentMenuItemBase;(9528291) Executing click handler for menu item 'S&ettings', hash code 32969802;
2018-12-19 09:50:14.6772;TRACE-2.3.1.4340;Rubberduck.Common.Hotkeys.Hotkey;Hotkey for the associated command Rubberduck.UI.Command.Refactorings.CodePaneRefactorRenameCommand was registered with id 49345;
2018-12-19 09:50:14.6928;TRACE-2.3.1.4340;Rubberduck.Common.Hotkeys.Hotkey;Hotkey for the associated command Rubberduck.UI.Command.Refactorings.RefactorEncapsulateFieldCommand was registered with id 49374;

hm, works here

Version 2.3.1.4330
OS: Microsoft Windows NT 6.1.7601 Service Pack 1, x64
Host Product: Microsoft Office 2010 x86
Host Version: 14.0.7212.5000
Host Executable: EXCEL.EXE

Version 2.3.1.4340
OS: Microsoft Windows NT 10.0.15063.0, x64
Host Product: Microsoft Office 2016 x64
Host Version: 16.0.4711.1000
Host Executable: MSACCESS.EXE

that was the weirdest "I'll show you mine if you'll show me yours" evar!

lol

I confirmed that it does seem to be responding to hot-keys, a Ctrl-backtick got me a parse. Sometimes the hot-keys don't work...

@FreeMan I should put the horizontal scrollbar on that. I'm thinking that dynamically resizing the form itself would be a little weird (it would also kick the scrollbar out from under the mouse).

AC exceptions get logged... but AC handlers don't write trace entries when they do kick in.. should they?

@Comintern that's a valid 3rd option and helps discoverability

@MathieuGuindon Wouldn't hurt for finding these kind of issues. ..

it's not like the log doesn't get large anyway...

and disk space is cheap (especially when the boss is paying for it:)

assuming logging is asynchronous, shouldn't hurt anything

Speaking of which, we should probably handle multi-duck logging at some point. IIR there was an issue for multiple instances contending for the log file.

[rubberduck-vba/Rubberduck] comintern created comment on issue #4662: Add/Remove references dialog box isn't wide enough

@MathieuGuindon typo in the 3rd paragraph - "cass"...

thanks, fixed!

@BigBen you might want to post answers as answers, it gets you more rep than comments :)

hahahaha, I'm bad about that.

@MathieuGuindon should I open an issue on the AC? Anything else I should test out first?

opens VBE's reference dialog

sad ducky

closes VBE's reference dialog. Goes to CE

LOL

@FreeMan sure go ahead :)

opens VBE's <thing>

sad ducky

closes VBE's <thing>. Goes to the duck's version

OOOOOOOOhhhhhhh...... It only works when the cursor is inside the quotes!

^not obvious, or <-- not bright

@MathieuGuindon never mind, works just fine when done properly.

uh, would help to know what was the <thing>

waitaminute, that's not related to the lightbulb moment, was it?

@FreeMan not doing that would be utterly annoying, wouldn't it?

When Ctrl-Enter at the end of a text string and just outside the close quote, Clipyduck needs to pop up: "I see you're trying to use smart concatenation. Would you like me to put the cursor back inside the quotes to make this work?"

@this any <thing> which the duck has replaced

@MathieuGuindon well, yeah, I guess so. I just haven't intentionally tried using it until now, and I hadn't really thought about how it would work, so...

the bulb was having a dim moment.

nah, Dim can't be Public ;-)

I wonder if it's worth it having a setting Override VBE's lame stuff with duck's übercool stuff...

a star for you for the dad quality

@this I thought there was... it's enabled by installing Rubberduck

[x] Hijack project references dialog

No, I'm referring to overriding the default menus like Tools -> References

^^

[x] Hijack all the things

or better, [ ] I want to go back to lame old VBE!

@FreeMan thank you, thank you, I'm here all week

lol...

to both @this and @MathieuGuindon

@FreeMan I can’t say my country. Yet it’s listed on his profile...

Mute, perhaps?

@IvenBach Yeah, saw those comments.

more like "don't need to say my country"

makes me very happy my country hasn't reached that level (yet)

BTW @IvenBach

Don't sell yourself short, you're dead sexy enough to have won a wife!

and keep her

@FreeMan kind of an achievement considering the long line of moronic tyrants we've managed to elect in last few terms....

if winning a wife involved duck tape and running from the law, don't share that...

@this yeah, scary stuff from both sides of the aisle...

/politics before we get our hands slapped

@FreeMan I periodically ask my wife why she married me.

Me: Why'd you marry me?
Wife: 'Cause you make me laugh ~giggles~
Me: Then you think I'm funny looking...
Wife: ~laughs~

@IvenBach I can relate to this.

She'll also frequently tell me You're stoopid! (Kinda tonge-in-cheek) and that's meant as a compliment. :)

side note, it took 14 years, but I finally got a legit, not-overkill use case for using array formulas in Excel: getting the nth match with index+match

can't wait for dynamic arrays to change the paradigm and make that much easier to grok

@MathieuGuindon why'd you need the nth match?

@Vogel612 I have one table with order details - so I know what fabrics I need, and how many units I need to cut for each, and when I need them.

then I have another table with fabric POs

that table has a row for each PO, so I know how much of each fabric is coming in and when

now I need to know if I have enough fabric to cut the orders, at any point in time

VLOOKUP will only give me the qty/ETA for whatever first PO is in the list for that fabric

oh gosh.

yeah

wait, is Mat using Excel as a database?

always :D

lol no, the data is on SQL Server

but the timeline with the aggregated customer groups and order types is a worksheet

...and it needs to be an actual production planning software

array formulas don't solve the problem of "depleting" a fabric PO

cumsum over all fabric types seems like your best bet, actually

it's probably a bit of a mess, though...

tis

totally unrelated: I have 6.8GiB of 7.7GiB of RAM used, kernel swappiness is set to 60, but the swap partition is only used to 0.45GiB of 3.7GiB ...

does kernel swappiness make a happy kernel?

depends on whether there's enough swap space and it's used irregularly enough

the closer to 100 the swappiness is, the more likely the kernel is to actually swap some stuff

it might be that the used memory isn't moving that much

It really gets annoying to get an email notification about the 443rd comment repeating same old chestnut from Excel UV...

it's a bit better now after it almost choked to death ...

that kinda seems to get it to work on doing some swapping

hi @Magisch!

Hello Mat

Didnt you use to be a mug?

yes!

@Magisch don't be silly. Mugs don't turn into humans....

I moved away from mostly vba lately

into C#?

and now you're looking for an awesome OSS project to contribute to? :D

no

javascript and tsql

^^

yay for T-SQL :)

And LaTeX templating

@TweetingDuck hmm didn't he say that already before?

@MathieuGuindon It's quite horrifying to look back at my earlier posts and realize that this is all code that is in production right now

@this I could have sworn I had liked & RTd it, but it wasn't showing as liked or RTd, ...so I re-liked and re-RTd

@MathieuGuindon Do you really absolutely need an array formula for that?

@M.Doerner some custom VBA function could do it... pretty sure without VBA or the dynamic arrays feature array formulas are the only hope for that

ive been spoiled by weak typing in javascript

just like you were spoiled with Variant in VBA :)

What does the array formula look like for this?

but for vba I really only learned with option explicit on all the time so I have no idea how type fuzziness can be used

I almost never used variant tbh

employer really didn't like using variants.

best not, yeah

@IvenBach I get the same answer

@M.Doerner {=INDEX(Values,SMALL(IF(Things="ABC",ROW(Things)-ROW(INDEX(Things,1,1))+1),Look‌​upValue))}

just like my current employer has a hard ban on using eval

unless manager override is obtained, the version control & ci will not let code with eval in it past

@Magisch the funny thing is that every time you typed a dot and no intellisense came up, you were probably using a Variant :)

many things return variants in various object models, esp. Excel

pretty sure that rarely happened

my vba experience was limited mostly to ms access

e.g. wb.Worksheets("name").something << late-bound

Hm, I think I'll try to turn that into an ordinary function later.

I recently returned to vba with some excel to write a program for the son of a coworker

#TIL I toggled the building door to be permanently open since Monday. Whoopsie...

Good thing I was out yesterday when they discovered that.

coworker wants to teach his 5 year old to start coding because the kid is interested

@Magisch great time to start.

gotta train the ducklings early!

I'm not convinced 5 years is the best time to start but the kid can write pseudocode that actually leads to implementable simple tasks

Just don’t expect him to understand + - / % or heck any operators....

ideally learn to read/write first, yeah

made a loop that iterates across a worksheet and checks each populated cell against a list of cell:image pairs in another sheet and copies the images if the texts match

also, if they grasp variables and operators and functions at that age, ...prepare to sign them up to private school!

well the kid can already do some 4th-5th grade math

no clue how but he seems to grasp the concept of a loop and incrementing a counter

wow

^

He’ll be in school ‘That’s a poor implementation of that formula. You can improve it by...’

kid is obsessed with soccer teams

so much so he calculates league scores and stuff

he has that in common with his dad

Use that passion to teach him math and science.

the coworker is a sysadmin, but seems to be interested in furthering his son's interests

I was always amazed how kids could calculate a pitcher's ERA (I'm told it's fairly complex), but couldn't solve 2x+6=27 for x...

IDK if that is still true but I seem to recall being told that psychologists thinks that kids can't do abstract until later age generally.