Starred posts

Malachi

Oct 22, 2014 15:15

Don't tease me like that @Mug (@Mat'sMug)

vba4all

Oct 22, 2014 15:14

@Malachi *2013

vba4all

Oct 22, 2014 14:15

I knew - I even asked for nearly the same thing in VBA

ptwales

Oct 21, 2014 18:57

@enderland Public Property Get Item(ByVal index As Long)

vba4all

Oct 21, 2014 14:25

Public Property PayDay(theMonth as Byte) as Date
' return the payday for the month
End Property

vba4all

Oct 21, 2014 14:07

what I am already thinking of doing with this is beyond whats currently p̶o̶s̶s̶i̶b̶l̶e̶ discovered in VBA :>

vba4all

Oct 21, 2014 12:57

wow haven't crashed my excel in a while.... til a minute ago

vba4all

Oct 21, 2014 12:40

see THIS

vba4all

Oct 20, 2014 16:43

amazon.co.uk/VBA-Developers-Handbook-Ken-Getz/dp/0782129781

vba4all

Oct 20, 2014 15:23

it should deal the cards and assign them to the right places

vba4all

Oct 20, 2014 14:49

i was kind of thinking the same thing how can I access class A in class B but not expose too much of class A to class B while there isn't a way to access it directly

Mat's Mug

Oct 17, 2014 11:49

I can live with factory methods

Mat's Mug

Oct 16, 2014 19:34

How about a CodeModuleParser class?

ptwales

Oct 16, 2014 18:56

groups.google.com/forum/#!topic/comp.lang.lisp/VAKbxfoys6o

vba4all

Oct 16, 2014 17:39

it's like if you know OOP and apply it within VBA you can pretty much solve any other VBA/Excel related problem, couldn't you?

vba4all

Oct 16, 2014 17:36

i've seen some MVPs on linkedin giving terrible advices... i mean saying properly bad stuff

RubberDuck

Oct 16, 2014 16:50

I've been kicking some a$$ on SO today

Mat's Mug

Oct 15, 2014 19:49

too many times "macro" in that text

Mark

Oct 15, 2014 19:31

lol

RubberDuck

Oct 15, 2014 19:30

da-fuq?

Mat's Mug

Oct 15, 2014 19:09

lol they block SO chat, but they leave CR alone! hahaha nice! Check out The 2nd Monitor :)

Mat's Mug

Oct 15, 2014 17:57

^^ I smell bad performance.. but can't think of a better way

Mat's Mug

Oct 15, 2014 17:37

side note: Enumerable.Join is ...complicated.

ptwales

Oct 15, 2014 17:25

I'm mortified.

ptwales

Oct 15, 2014 17:22

It's like all pseudo inheritance patterns in VBA is exactly backward.

Mat's Mug

Oct 15, 2014 16:58

that's the part we all wish worked in VBA

Mat's Mug

Oct 15, 2014 16:24

and now I finally understand how Enumerable.Aggregate works!

Mat's Mug

Oct 15, 2014 16:21

^^ @ptwales why I don't like optional parameters ;)

Mat's Mug

Oct 15, 2014 15:15

> I like that suggested tags are c# and linq - means I did something right!

Mat's Mug

Oct 15, 2014 14:35

unicorns

vba4all

Oct 15, 2014 13:44

@Mat'sMug yeah I am still kind of active on SO... I just want to get the 20K rep and then I am pretty much off (unless I spot a really interesting question which will be probably once in a year or two lol )

Mat's Mug

Oct 15, 2014 13:12

I'm trying to implement Enumerable.Aggregate, but I have no idea what I'm doing :)

Malachi

Oct 15, 2014 13:08

We do love our Memes on Code Review... lol — Malachi 15 hours ago

enderland

Oct 15, 2014 13:08

I like VBA, I just wish everyone who wrote it had some level of software background rather than being hackers with literally no idea what they are doing

Mat's Mug

Oct 15, 2014 01:52

in The 2nd Monitor, 1 min ago, by Mat's Mug

at least in VBA they're explicit about being Friend before they play like that.

ptwales

Oct 14, 2014 20:53

Ditching regex would be the best solution.

Mat's Mug

Oct 14, 2014 17:30

Well C# regex are nice.. scripting/vba regex are a PITA

RubberDuck

Oct 14, 2014 15:49

That's almost exactly why I created that "Enumerable" class. So I could pass a range in and call Distinct on it.

RubberDuck

Oct 13, 2014 23:52

I'm going to rename this room "Abusing VBA like a red headed step child"

enderland

Oct 13, 2014 23:03

Or is that a "Mat's way" :)

Mat's Mug

Oct 13, 2014 18:40

I'll be home in a few hours, will be working on a Delegate class :)

Malachi

Oct 10, 2014 21:13

@RubberDuck randomlyle.blogspot.com

Malachi

Oct 10, 2014 20:35

0

Q: Checking for missing values in several columns of a spreadsheet

Basically I had 3 columns of Data Adjudicated Cases Not Adjudicated Cases All Cases and I wanted to get a list of all the cases that were missing from Column A and Column B, with a little help from @RubberDucky and his really cool Enumerable.cls (Found on GitHub in His VBX Repository) I used...

RubberDuck

Oct 10, 2014 18:54

@Mat'sMug I'm one of those stars.

Mat's Mug

Oct 10, 2014 17:56

@RubberDuck now how about wrapping it up with some ISourceControlProvider interface, with Commit and Update methods, and then implementing it for both GitHub and SVN? ...and then you can have toolbar buttons in the IDE to configure the provider, repository URL and actually update & commit straight from the IDE! :)

Malachi

Oct 10, 2014 14:47

> Thing is, despite all its flaws, I have to admit I like VBA

RubberDuck

Oct 10, 2014 02:19

retailcoder.wordpress.com/2014/10/05/…

RubberDuck

Oct 9, 2014 20:58

It gives you options about what language you want to use though. It basically just exposes an API to use.

RubberDuck

Oct 9, 2014 20:52

@Malachi When you put it that way, I don't anymore. lol

RubberDuck

Oct 9, 2014 19:02

I've still not found a way to debug it beyond message boxes and trial/error.

VBA Rubberducking

VBA Rubberducking