VBA Rubberducking

Duga

00:03

REFRESH!

[Minesweeper] 108 Games Played. 77 Bombs Used. 16309 Moves Performed. 8 New Users

[rubberduck-vba/Rubberduck] 2 issues opened. 6 issue comments

Duga

08:21

[rubberduck-vba/Rubberduck] monoscale created comment on issue #5824: False positive AssignmentNotUsed inspection

> 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

[rubberduck-vba/Rubberduck] monoscale edited comment on issue #5824: False positive AssignmentNotUsed inspection

> 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

FreeMan

12:03

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...

IvenBach

16:25

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.

FreeMan

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.

IvenBach

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.

FreeMan

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...

IvenBach

IMO if you ever have to turn off manual calculation something is unwell and needs to be remedied.

FreeMan

Congrats! You've just described several of the workbooks I have the joy of working with!

IvenBach

16:36

:offers-previously-used-condolences:

Just keep learning better ways.

Quack Exchange

18:13

0

Q: ComparerGUI with MVVM dialog to allow user input in sorting algorithm

download 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...

Duga

20:11

[rubberduck-vba/Rubberduck] jim-oflaherty-jr-qalocate-com created comment on issue #5842: Refactor Excel Worksheet Formulas containing VBA function calls to depend upon a "formula facade"...

> > 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

[rubberduck-vba/Rubberduck] jim-oflaherty-jr-qalocate-com edited comment on issue #5842: Refactor Excel Worksheet Formulas containing VBA function calls to depend upon a "formula facade"...

> > 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

Duga

23:48

[rubberduck-vba/Rubberduck] 1391 stars vs. [decalage2/oletools] 1675 stars

We're all idiots

Transcript for