VBA Rubberducking

This chat has moved to Discord: discord.gg/MYX9RECenJ
Dec 10, 2022 20:25
d*mn that's slick
Dec 9, 2022 02:51
solid!
Dec 8, 2022 19:35
screaming for the ducky
Dec 8, 2022 19:33
that feeling when a "Process Improvement" analyst shares his VBA, and it's got GoTo and Select and Activate, and it's even VBA to begin with.
Nov 2, 2022 14:43
@MathieuGuindon lol
Oct 26, 2022 14:02
Oh yeah, this looks like exactly what I need, thank you!
Oct 26, 2022 14:00
I like those types of books hahaha
Oct 26, 2022 13:59
Context: switching from on-prem data warehouse (Teradata) to Azure.
Oct 26, 2022 13:56
Fairly deep!
Oct 26, 2022 13:41
Any recommendation for a good resource to learn T-SQL?
Oct 20, 2022 16:02
hahahahahaha
Oct 20, 2022 16:00
pretty!
Oct 14, 2022 15:30
Bc Bookmark has been rebranded/revamped to "Saves". But yeah, it's annoying.
Oct 6, 2022 17:27
hahahahahahah
Oct 6, 2022 17:21
Whatever happened to This?
Oct 4, 2022 20:10
Well yeah, I definitely agree on the buffer
Oct 4, 2022 20:00
eesh that's a rough commute for a uni meeting
Oct 4, 2022 19:56
currently sitting in a (useless) meeting of 12 people
Oct 4, 2022 19:55
what, you actually work during the workday?
Sep 30, 2022 17:19
lol
Sep 30, 2022 16:36
Well put. I couldn't have said that :-)
Sep 30, 2022 13:01
Question just posted with a shout-out to RD
Sep 30, 2022 13:01
0
Q: How to iterate through the members of a standard module

hymcedMy goal is to list the procedures exposed by the compiled VBProject, as visible in the Excel Macros menu or when typing a cell formula which makes appear availble UDF. A Solution that list any member (Enum, Sub, Function, etc.) of a CodeModule or of the full VBProject would be ideal. I am not loo...

Sep 29, 2022 13:03
It's amazing that we get Python questions in a VBA rubberducking chat room ...
Sep 26, 2022 18:29
d*mn, looks awesome
Sep 15, 2022 17:05
@Vogel612 seems about right
Aug 26, 2022 16:54
^ Linux?
Aug 26, 2022 16:28
I noticed as well.
Aug 17, 2022 16:02
yay for new hardware
Aug 17, 2022 15:47
@Duga I recognize that username
Aug 15, 2022 14:44
Wasn't the Perseid meteor shower this weekend? obviously not related to RD but your comment made me think of it...
Aug 12, 2022 14:12
I appreciate the feedback!
Aug 12, 2022 14:11
The blank line would definitely help
Aug 12, 2022 14:10
Yah I thought about something like this, including the blank line!
Aug 12, 2022 13:57
I have not installed RD on my work machine
Aug 12, 2022 13:56
not sure
Aug 12, 2022 13:56
good idea
Aug 12, 2022 13:55
ah yeah I can visualize that
Aug 12, 2022 13:54
ah maybe I laughed too soon... seems like you're suggesting the second option I proposed?
Aug 12, 2022 13:53
hahahahahahaha
Aug 12, 2022 13:50
Been writing too much Python lately and it's bleeding over into VBA lol
Aug 12, 2022 13:50
And will get longer if I add more params
Aug 12, 2022 13:49
I don't want to do that though, too long
Aug 12, 2022 13:47
This looks even uglier.
Aug 12, 2022 13:47
Function MakeRange( _
        ByVal Sld As Slide, _
        ByVal WantedShapes As String _
) As ShapeRange
    Set MakeRange = Sld.Shapes.Range(WantedShapes)
End Function
Aug 12, 2022 13:46
This looks ugly to me bc the indentation of the parameters aligns with the indentation of the function body. Any suggestions as to how to improve?
Aug 12, 2022 13:45
Function MakeRange( _
    ByVal Sld As Slide, _
    ByVal WantedShapes As String _
) As ShapeRange
    Set MakeRange = Sld.Shapes.Range(WantedShapes)
End Function
Aug 10, 2022 17:11
but I could be wrong
Aug 10, 2022 17:11
yeah that looks like just you
Aug 10, 2022 15:34
Shared the Battleship workbook with the intern on my team today - he was wowed.