@23fc9a62-56de-47fb-97b4-737890 I wish... the SO community ad was never done, I haven't touched block completion since last winter (fall?), my writing is stalled (wiped a whole chapter the other day), I haven't published any articles this month and the month is coming to an end already, ...pushed that hotfix commit at 2AM last night...
> We have many features, some more discoverable than others. We have memory pressure and performance issues, and only a vague intuitive idea of what's in our users' VBA projects that's based on our own individual experiences. We do have logging, and it *does* help (a lot) with debugging and diagnosis, but statistically a bug report or log file is nothing but an anecdote.
If Rubberduck had an opt-in setting to enable transparent telemetry (there's no way this is getting implemented without mak
yeah there's been talks about it, but I never went public (not beyond this chat anyway) about telemetry talks for Rubberduck (not until this week in a Twitter reply though)
@PeterMTaylor That's was a very interesting read. I don't know what's #Right in terms of programming but learning about new ways of thinking can't be bad. Bad code can be written in any language.
@IvenBach um, they didn't bother to name any of their stuff? Just took the default names auto-generated by VBA when they added their userforms & controls?
Keep in mind that is only a snippet. There are ~20 of userforms with several controls all over.
Private Sub CheckBox1_Click()
Me.CheckBox2.Enabled = Me.CheckBox1.Value
Me.TextBox6.Enabled = Me.CheckBox1.Value
If Me.CheckBox1.Value Then
Me.TextBox6.BackColor = &H80000005
Else
Me.TextBox6.BackColor = &H80000004
Me.TextBox6 = vbNullString
Me.CheckBox2.Value = False
End If
End Sub
^ :offers-token-help: Maybe this can help ease your pain.
@23fc9a62-56de-47fb-97b4-737890 Is that one of the Coke Koch brothers?
Yay! The newtwork finally let me DL a prerelease again!
Version 2.4.1.4869
OS: Microsoft Windows NT 10.0.15063.0, x64
Host Product: Microsoft Office 2016 x64
Host Version: 16.0.4873.1000
Host Executable: MSACCESS.EXE
@FreeMan no, that's not a typo
Any ideas why this is getting picked up by the ToDo Explorer?
derp - Ignore...
okey doke.
I added that in the hopes of finding all the @Ignore annotations so it would be easy to pull them as things got fixed...
that file is no longer showing in the Modified section of a git status. Does that mean I've overwritten whatever changes it saw in that file with whatever was previously committed?
What it says: Your credit limit has been increased based on your payment history.
What they mean: You're not letting us screw you over with interest payments.
re telemetry: We should be able to to something useful with the data we get, so things like usage-statistics are probably okay, SLL prediction failures aren't really actionable...
code metrics are irrelevant for us, considering we don't currently check the halstead volume, so the complexity of the parsed code is basically a black box
@23fc9a62-56de-47fb-97b4-737890 FWIW, I think it might be also interesting to track the time of refactor followed by an undo. that might be helpful in indicating that a refactoring (or any action) isn't what user wanted
it'd have to be naive, though - no sense in trying to track if it's refactor + type something + 3 undos to count.
only refactor immediately followed by 2 undos... similar in idea to Google's .... "bounceback" (?) metric
(the metric where they see that an user pressed the back button after clicking a search result which then lowers the search result on the assumption that it wasn't what the user wanted)
@Vogel612 granted (to an extent), but it wouldn't be collected without an explicit consent.. basically everything would be opt-in. this data could be used for prioritizing work on an eventual TypeScript transpiler, for example; metrics could be used to objectively measure the quality of VBA code - and a time-series could be used to measure whether using Rubberduck actually improves VBA code quality.
If I need an enum and a Property of that type on 2 of 3 Implementations of an interface, does it make the most sense to put it on the Interface, or individually only on the Implementations that it applies to?
I would think on the Interface then the one (and future ones) that don't need it would just return Null for that property, right?
but yeah, defining an enum on the interface makes the most sense to me - if there are no implementations, the enum is right there in the module it's used in. When there are implementations, the enum is readily accessible.
Quite often those two terms used interchangeably, but there is an important difference. In my opinion, there is a similar difference as between stubs and mocks. Stub i.e. Isolation Framework only provides predefined outputs, and thus isolates "test" from external system with complex internal stat...
Excel, 1243 1206 1180 bytes
-37 bytes by subtracting from all the dates
-26 bytes by by fiddling with the subtraction values
=CHOOSE(MATCH(A1-65^4,{39805,119679,159679,239679,319679,399679,439679,519679,559679,559779,599679,639679,650084,679679,719679,759679,799790,839679,919679,959679,960294,9...
I question the notion of writing smallest code possible -- Excel might be able to do that but you're talking about installing a gigantic product just to run a small program, in comparison to other languages that can compile to a small executable.
Also, I noticed that there's more answers using some kind of esotoric programming languages.
VBA, 58 Bytes
Anonymous VBE immediate window function that takes no input and makes VBA sing its own happy birthday song, alone.
h="Happy Birthday ":t="to You":?h;t:?h;t:?h"Dear VBA":?h;t
Excel VBA, 687 686 686 681 Bytes
From the problem statement:
However, I'm also rewarding other witty submissions with up-votes (and I encourage everybody to do so as well). Therefore although this is a code-golf contest, not-so-short answers are also welcome.
Code
Full subroutine that ...
Your job is to animate this circle illusion. It looks like the points rotating inside of the circle, but they are actually just moving in straight lines.
Criterias
The result has to be animated. The way you do the animation is irrelevant, it can generate a .gif, it can draw to a window, some...
Given that we can't resolve any further, even if the it's only one intermediate that's invalid, I don't see any point in resolving beyond the first failure, and thereafter treating the remainder as single expression of unknown nature
that is, we'd have a unresolved declaration of NotThere.Neither.Hello(15), rather than just NotThere
@this what if foo.NotThere.Neither is LHS of an assignment, wouldn't we want to know that the assignment target is Neither and not foo? I can see that causing issues / false positives in some contexts
Excel, 1243 1206 1180 bytes
-37 bytes by subtracting from all the dates
-26 bytes by by fiddling with the subtraction values
=CHOOSE(MATCH(A1-65^4,{39805,119679,159679,239679,319679,399679,439679,519679,559679,559779,599679,639679,650084,679679,719679,759679,799790,839679,919679,959679,960294,9...
VBA, 58 Bytes
Anonymous VBE immediate window function that takes no input and makes VBA sing its own happy birthday song, alone.
h="Happy Birthday ":t="to You":?h;t:?h;t:?h"Dear VBA":?h;t
Your job is to animate this circle illusion. It looks like the points rotating inside of the circle, but they are actually just moving in straight lines.
Criterias
The result has to be animated. The way you do the animation is irrelevant, it can generate a .gif, it can draw to a window, some...
VBA Rubberducking
VBA Rubberducking