« first day (2618 days earlier)      last day (83 days later) » 

12:03 AM
REFRESH!
[Minesweeper] 108 Games Played. 77 Bombs Used. 16309 Moves Performed. 8 New Users
[rubberduck-vba/Rubberduck] 2 issues opened. 6 issue comments
 
 
8 hours later…
8:21 AM
> I am having the same issue with the following code:

```
Public Function FormBase_IsValid() As Boolean
Dim validInput As Boolean: validInput = True

If Not ValidationHandler.IsTextBoxValid(TextBoxAge, Numeric) Then validInput = False
If Not ValidationHandler.IsTextBoxValid(TextBoxYear, Numeric) Then validInput = False

FormBase_IsValid = validInput
End Function
```

This code checks if the form has any invalid inputs. The default cause is that the input is valid an
> I am having the same issue with the following code:

```
Public Function FormBase_IsValid() As Boolean
Dim validInput As Boolean: validInput = True

If Not ValidationHandler.IsTextBoxValid(TextBoxAge, Numeric) Then validInput = False
If Not ValidationHandler.IsTextBoxValid(TextBoxYear, Numeric) Then validInput = False

FormBase_IsValid = validInput
End Function
```

This code checks if the form has any invalid inputs. The default cause is that the input is valid an
 
 
4 hours later…
12:03 PM
TFW your Excel worksheet is showing you weird numbers after entering large amounts of data with Calculation = Manual. Because you forgot to calculate the sheet...
 
 
4 hours later…
4:25 PM
Public Sub DuhChecks()
    Dim messagePrompt As String
    If IsInManualCalculation(messagePrompt) Then
        MsgBox messagePrompt, TITLE:="Change to automatic calculation"
        Exit Sub
    End If

    'Additional checks as required
End Sub


Private Function IsInManualCalculation(ByRef outMessagePrompt As String) As Boolean
    If Application.Calculation = xlCalculationManual Then
        outMessagePrompt = "Application is in manual calculation."
        IsInManualCalculation = True
    End If
@FreeMan ^ Past-Iven had a less clean version of this. It helped me catch a few oopsie-woopsies I'd forgotten to check.
 
Yeah, I only spent the best part of an hour trying to figure out why a value was wrong when I KNEW the calculation worked properly and the inputs were correct.
 

We're all idiots

Aug 22 '19 at 19:34, 15 minutes total – 24 messages, 6 users, 1 star

Bookmarked Aug 22 '19 at 19:52 by Mathieu Guindon

^ I've learned from this pond that it isn't always complicated.
 
In general, I probably need to make all my workbooks macro enabled and have an on_close event handler that sets calculation = xlCalculationAutomatic. I've forgotten that far too often and had panicked users calling me wondering why things weren't working right...
 
IMO if you ever have to turn off manual calculation something is unwell and needs to be remedied.
 
Congrats! You've just described several of the workbooks I have the joy of working with!
 
4:36 PM
:offers-previously-used-condolences:
Just keep learning better ways.
 
 
2 hours later…
6:13 PM
0
Q: ComparerGUI with MVVM dialog to allow user input in sorting algorithm

Greedodownload Bit of an esoteric title, but let me explain. I wanted to create an IComparer that can be supplied to a sorting algorithm, which rather than using the >, <, = comparison operators on the two values, or some custom property of 2 objects like this fantastic PropertyComparer class, instead...

 
 
2 hours later…
8:11 PM
> > Could you possibly add a concrete example of what happens to your VBA and worksheet formula before and after? I'm struggling to visualise it sorry. (Ps I'm not an RD official maintainer/🦆, just interested)

Absolutely.

I have received a workbook containing VBA code (across +30 modules) that has 11 worksheets. 8 of the worksheets contain thousands of formulas. These formulas all call a small number of functions in the VBA code. These 8 worksheets also each have 4 buttons that call into
> > Could you possibly add a concrete example of what happens to your VBA and worksheet formula before and after? I'm struggling to visualise it sorry. (Ps I'm not an RD official maintainer/🦆, just interested)

Absolutely.

I have received a workbook containing VBA code (across +30 modules) that has 11 worksheets. 8 of the worksheets contain thousands of formulas. These formulas all call a small number of functions in the VBA code. These 8 worksheets also each have 4 buttons that call into
 
 
4 hours later…
11:48 PM
[rubberduck-vba/Rubberduck] 1391 stars vs. [decalage2/oletools] 1675 stars
 

« first day (2618 days earlier)      last day (83 days later) »