« first day (2088 days earlier)      last day (44 days later) » 

12:00 AM
[Minesweeper] Games Played: 93, Bombs Used: 50, Moves Performed: 12477, New Users: 10
[rubberduck-vba/Rubberduck] 8 commits. 1719 additions. 941 deletions. 4 issues closed. 1 issues opened. 8 issue comments
12:30 AM
Q: Attempt to calculate draws faster in VB.Net

Norisor MariusI created this calculation algorithm, unfortunately, it works a little hard for more combinations. how should it be improved for faster operation? Private Sub BttRemize_Click(sender As Object, e As EventArgs) Handles BttRemize.Click If CBRealTime.Checked = True Then Dim myP...

7 hours later…
3 hours later…
9:43 AM
@MathieuGuindon What Have You Done To Me Mug? codereview.stackexchange.com/a/237775/131748 I Just Can't Stop. Must Help Others Improve Their VBA Coding Habits.
:derp: 1:45am. Yeah it's way past bed time...
If your goal was to unlock the achievement you succeeded all to well.
2 hours later…
11:38 AM
Q: Outlook - put all ungrouped contacts in a separate folder

vba-coderI have linked my icloud contacts to outlook, and wanted to display all contacts which had not been grouped. I wrote this sub for that: Option Explicit Sub Ungrouped() Dim NS As Outlook.NameSpace Dim c1 As Outlook.ContactItem, c2 As Outlook.ContactItem Dim iCloud As Outlook.MAPIFolde...

2 hours later…
2:08 PM
@IvenBach that is an amazingly good answer that I will not leave unrewarded. Keep 'em coming!
3 hours later…
5:15 PM
Was my big O statement correct? Everything I’ve learned leads me to believe it is. Yet I’ve been wrong before
5:39 PM
assuming the lookup in the HideSheetsLookup is in fact O(1), it's correct
not all map implementations guarantee that
in fact it's one reason why people use Hashes: to decrease lookup time
Mkay. I’ll one day get to use hashes.
6:01 PM
> Agreed. There are name validations with user messages are available from VBAIdentifierValidator.TryMatchInvalidIdentifierCriteria(string name, out string criteriaMatchMessage). The criteriaMatchMessage contains the feedback regarding the reason for a validation failure. VBAIdentifierValidator is used in the RefactoringRename UI, but currently, the criteria messages are not surfaced to the user.
4 hours later…
9:45 PM
Q: aggregate sheets from many excel workbooks into one workbook

dactyrafficleI want to put the worksheets from several (2-5) excel workbooks (files) into one single workbook. The names of the workbooks are not standardized and so I opted for a dialog box to select the workbooks. Here is the code. It meets the basic requirement that all the worksheets (sheets actually) f...


« first day (2088 days earlier)      last day (44 days later) »