yep.. very easy to do

Enums. Any issue with having them in a class module or a document module?

When you're just writing a list of values, then Excel is just fine. The problem comes when they start trying to use Excel like a database (e.g. querying, creating data entry forms, performing integrity checks, etc.)

@this well yeah but excel is still better than something like word isnt it?

@IvenBach no, but if an interface uses them I'd typically declare them in the same module as the interface. otherwise, they could be defined in your Constants standard module

I don't know. If you're building a Word VBA project, you might end up doing something to store the values somewhere.

But again, TBH, I never really liked the idea of writing VBA code directly in documents. That doesn't make sense to me.

document properties or something.. there's a field somewhere that can accept data that can be persisted with the host document

In case it wasn't obvious, I'm an Access guy, and I use Access as the giant automator for everything Office.

yeah i feel like i maybe should be using access more for what im doing tbh

does it work well with excel

So I have the data in .... actual tables :O :O .... and just build word documents or Excel spreadsheets for reporting.

managing doc props was a way I used in the past and I found it clunky

Oh definitely! I build Excel reports from Access all the time!

okay i might have to consider this then

some things in my app are definitely

and they have their pretty little forms for doing data entry and it's much easier to control the validation & protect data integrity.

what do you mean by data entry specifically

user keys in some data that needs to be persisted in some record somewhere

That said, 90%+ of my Access projects usually use SQL Server as the backend, rather than Access.

What Mat said.

oh

@theVBE-it'srightforme If you do any ammount of serious coding in VBA-landia I strongly suggest editing the default colors. It helps immensely.

so I mainly use Access as basically an application builder

what im doing in excel is similar to that but not exactly i dont think

Trust me. Everyone's building an application.

The mistake comes in the fact that every users wants it to be like Excel.

i was basically trying to build one using Excel as the UI for that reason

i think

@IvenBach how?

@this best feedback I got for that WPF CRUD grid app I've been working on: "It's so much better than working in Excel!"

I don't remember -- maybe @MathieuGuindon remembers --- Joel Spolsky made a video explaining how people fall in the same trap over and over when the users make feature requests.

Nice!!!

users repeatedly making feature requests is what got me to rubber duck basically

That's exactly how it should be --- purpose-built rather than hijacking some spreadsheet.

To clarify, not just any kind of feature requests --- they usually frame their feature requests in way like "hey, can you make it work like Excel does?"

oh loool

filtering, sorting, copy-pasting, etc.

feature requests by itself isn't bad; but when they want to make it like Excel... that's where you need to gently put them down.

oh yeah that is not what i am dealing with

thankfully it appears

excel is honestly really just a ui framework at this point for me

YES!!!

@theVBE-it'srightforme ^

@IvenBach TBH I'm very reluctant to tweak those... it's been 25 years, I'm used to this.

@IvenBach Behold the glory of 16-bit color palette!

I like it dark. @this and @FreeMan have it with bright colors. I have no clue how they use it like that.

Bright?

idk why but i kinda like the defaults

Mug is just a badass and can understand code just by thinking about it.

i will play around tho

That's prolly why he's never changed the colors.

For me, if I use dark, it look quite jarring with the toolwindows shining white background.

@MathieuGuindon oh that is a good thing?

so blue was a compromise

That blue is still too bright for me.

Oh if I could change those toolbars to a very dark grey...

when RD hijacks the code panes (yes, that's AvalonMentions++;), I'll be happy to configure an actual theme, ...with better colors than the 1992 craptastic default palette

That will be sublime.

"1992 craptastic default palette"

@IvenBach no, I accidentally said toolbars but I meant toolwindows

oh hi userform controls

those won't even change.

@theVBE-it'srightforme but these are the productivity things that make hanging around in chat so helpful.

@IvenBach yeah i see it!

There was that issue someone submitted showing a dark theme. Granted the link to where the got it from was crawling with trojan's and other nasty STDs.

I guess DTD (Digitially Transmitted Disease) would be more pedantic.

lol

well the solution they got was to literally rewrite VBA7.DLL (IIRC), tweaking the bits that define the color palette. no way Rubberduck was going to do that

Does connect and ethernet cable constitute Not even going to go there.

if it's that a big of a problem, you could just change Windows theme

misses lilac theme from Win95

but it's not without its problem.

Lilac? C'mon. Hot dog stand was better.

Win10 has a dark theme default at least.

@this for a "countdown to heart attack" version of "better", sure ;-)

I wonder if they made one for Windows 10, lol.

I bet there's a Chrome/FF extension to get the beloved theme onto your favorite browser

(no, not gonna look - I like keeping my eyeballs in their sockets)

lol. would make for a good April Fool's prank.

You're missing one more differentiation, I think.

^^ @theVBE-it'srightforme has the difference between a label and an identifier readily apparent.

Keyword and Identifier should be different, no?

oh that is useful

@this yes

@IvenBach Why CourierNew?

#defaults

courier new was how i learned to type so...

:3

^ same

Thanks to Thunderframe (RIP), I install Source Code Pro

I changed it to Consolas once, felt nice but weird at the same time

@M.Doerner Just be glad I don't use Comic Sans!

Unfortunately I've seen someone do that.

Change it to Consolas and thank yourself the next time you have handl and hand1 or similar stuff.

Unironically.

:|

can you use comic sans?

Yeah.

brb editing my VBE settings

Who's got the 2x4?

the question isn't whether you can, but whether you should!

lol

should isnt a question at all tho

should implies ability, though. No point in asking if you should if you can't.

which is why we focus on the can :p

i wonder why comic sans became the meme terrible font

I don't hate it but designforhackers.com/blog/comic-sans-hate helped educate me about it.

I need to pick up source code pro as a font.

Thunderframe posted alink to it here

When chat search works.

> Comic Sans was originally designed to be used in the talk bubbles of a program called Microsoft Bob.

OMG

> The font wasn’t completed in time to actually make it into the program, but it lived on to eventually ship with Windows 95; and that’s when the font really got ugly.

Blame Bob.

great article, thanks for sharing :)

^

> This is a monumental moment in history – right up there with the invention of printing – for common people to suddenly have the power to typeset and print documents.

I shall choose..... Comic Sans!

If there's a dislike towards something I try to know why. Educating myself on what I don't know helps me make an informed decision.

That article was really good.

hitting the road, bbl