Were we too friendly and scared 'em away?

better that than being too unfriendly and scaring 'em away :)

that said our explicit-write whitelist is getting pretty thick

@BloggingDuck @MathieuGuindon should I open an issue for suggestion to the post?

huh? no..

feel free to post suggestions here, or to comment on the post itself :)

mkay. Images and doing all the pre-work of it for you came to mind.

@MathieuGuindon I actually cleaned that up a while ago IIRC

@IvenBach yes its a wholly unfamiliar experience on the internet

actually i just forgot i had to make a quick phone call

thank you for the friendly reception

I don't mind a "Hello, nice to meet you." but when people seem overly eager/friendly at first it is a bit off-putting.

@MathieuGuindon ill try to get to 20 rep at some point so you can remove me :p

@IvenBach

oops

We're here to help and as Mat (Mug) said ask any questions.

@user12506685 that's pretty easy, and we can help! got any working VBA code?

i was going to say i agree when it comes off as fake

but neither of you did lol

define "working" oh cool

@user12506685 If you want to edit a msg you can UpArrow through any of your last 3 messages to edit them. To correct them as needed.

does what you need it to do, whatever that is?

@IvenBach it's actually any message posted in the last 2 minutes

@IvenBach ty

i guess i do

but its not really recent nor is it good

ok, quick briefing on the Code Review Stack: you have code that works as intended, so you present it to reviewers in a "question" post where you describe what the code does, why it does it, etc.; basically you walk reviewers through it as you would one-on-one

and then reviewers "answer" with feedback on any/all aspects of the code

and that gets rep?

when the post is well-received, yeah

doesn't take much really

two upvotes is enough since the changes to reputation

well i can explain things well but i dont think any code i have currently functional is worth the time

you might be surprised at what you learn from a review, actually

^

that's kinda the whole point of it 😃

i more mean that its bad and I know its bad

think of like every general bad vba coding practice you mention

basically the thing is that i started working on this project

when i had a really poor conceptual understanding of programming

it's okay - then if you get no answers you can self-review with your own observations!

perfect candidate for cleanup and code review after :)

id honestly rather just wait and do it with the component im working on now

once it gets functional

no rush

sounds fair :)

since it actually uses Implements more than zero times

lol

remember that no matter how terrible of a coder you think you are, there's always someone worse somewhere

(the inverse is also true)

that is good advice for any endeavor haha

honestly its not that I think im necessarily bad at this point

thanks in no small part to you of course

IDK what your impression is of Stack Overflow, but just FYI the atmosphere is much, much more laid back over here on CR

i legit lol'd at the first part of that sentence

I mean, we still mercilessly close off-topic questions :)

and redundant ones too?

that's ...harder

check this out: fizzbuzz

oh true

(that's right, 185 FIZZBUZZ implementations on site!)

that is the nature of it being review vs "how do i do this"

surprised its not more

yeah. a side-effect of that, is that every single on-topic question on this site contains a working solution for a particular problem

Todo: create a new programming language named fizzbuzz

FWIW the VBA tag was seeded by some nutbag weirdoes

A duck and a mug, wasn't it?

whistles innocently

lol

also back to what i was saying, basically what i have functional is either kinda meaningless in its functionality outside of the workbook

so @user12506685 I'm curious, how did you come about Rubberduck?

or is something that should be done properly

and isnt because i havent had time to fix it

uh

im trying to remember

lets see

oh it was your (legendary imo) comment on the "is vba an OOP language" discussion

i dont exactly remember why i was looking up that question specifically

i think i was actually just bored of what i was doing and needed a break so i looked for that because i'd remembered oop from somewhere else

and thought that people considered oop "real" programming

so then i wanted to see what people thought about vba wrt that

then it stuck with me because it was a good read

and after i looked at the battleship workbook for a bit i realized it was what i needed to do to solve the problems i was having with my own project

that is the short answer

gotta go, bbl

Mug WRT Document Modules. You could explain how to enable the VBIDE Extensibility (Tools>References>Microsoft Visual Basic for Applications Extensibility 5.3) object model. I had to think about this for a moment myself.

wait lol vba is in autocad?

there we go my name updated <3

^^ For that reason.

interesting...

I like that your name and profile pic show now, because that's not common for 1-rep accounts

I assume it's been recently added that explicit write access also grants you the full profile

oh i was going to ask why it wasn't showing

hmm ...

i just assumed it was because i made the profile on SO lol

nah, it's because there was an incident a few years back around someone using profile pictures to do more or less evil things with, so people that don't have talk privs also don't get to have a fully visible chat account

@Vogel612 this is better than "user12506685" i imagine?

A slight rewording:

This workbook
In the VBA project, the host document is referred to with an identifier, and that identifier is (by default anyway, and renaming it is not something I’d recommend doing) ThisWorkbook.
--> In the VBA project, the host document is referred to with an identifier, and that identifier is, by default anyway, ThisWorkbook (renaming it is not something I’d recommend).

@Vogel612 oh that makes sense

@theVBE-it'srightforme I personally don't mind, because if worst comes to worst I have a few tricks up my sleeve to track down where I should know you from :)

you're scaring me :0

@IvenBach i agree with that revision

nothing nefarious

still its the idea

I'm basically alluding to the fact that I know the "recent" tab of chat profiles is paginated.

edit that before someone sees it!

lol i wasnt thinking of that sort of trolling

i think im getting old :/

@IvenBach Finally catching up with you - posted some C# on Code Review :)

anyways should go for a bit as well

@IvenBach good call, I do that way too often (open a parenthese and then go on an on and on....) will edit when I get home

are you sure you're not secretly a german? Run-on-sentences (Bandwurmsätze) are our local specialty....

that must be why I felt compelled to take German I back in college (dang that was already 20 years ago), ...I did score pretty well (~95%), but to a German native the class would probably have felt appropriate for 6yo kids

I ❤ German

</mug>

@MathieuGuindon i feel like that is a very common error in writing because its the natural way to think about it

as the writer you are aware of what "that identifier" is referring to so you're not as sensitive to making sure it is mentioned

but you are sensitive to making sure you dont forget every important piece of information you want to mention regarding it :)

also i do have actual questions about vba but im not exactly sure how to explain it

okay CR/SO question: when is the appropriate time to answer in a comment vs in an actual answer?

you don't have the reputation to comment in the first place, so you don't really need to worry about that right now

but as the name implies: comments are for commenting, answers are for answering

so if you have an answer, that goes into the answer box.

usually even when the answer is only partial

@Vogel612 im working on that!

i wasnt sure because it seems like that line blurs a bit in practice, from what ive seen

but it is a fairly easy distinction to keep in mind

yea it does and I'm trying to get people to not do that whenever I see it :)

at least on CR

that said: bedtime for me

Night y'all

Night.

@Vogel612 i will note that :)

Accessing Worksheets
The magic Sheet1 identifier comes from the (Name) property of the Sheet1 document module under ThisWorkbook in the VBA project: set that property to a valid and meaningful name...
--> Instructions on how to do this really help inexperienced users.
	Double click on the object in the Worksheet object in the Project Explorer to display the code behind.
	In the menu at the top View>Properties Window (Hotkey: F4) to display the properties.
	The first property (Name) at the top is the Worksheet.CodeName property. This is what you rename to a valid/meaningful name.

^ @MathieuGuindon Another one that I found to be large comprehension hurdle.

I love how CodeName is represented as (Name) in the properties window

Wait, is it .Sheets() or .Worksheets()?
The first thing to note, is that they aren’t language-level keywords, but member calls. If you don’t qualify them, then in the ThisWorkbook module you’ll be referring to Me.Worksheets (i.e. ThisWorkbook.Worksheets), and anywhere else in the VBA project that same code be implicitly referring to ActiveWorkbook.Worksheets: that’s why it’s important to properly qualify member calls. Worksheets is a member of a Workbook object, so you explicitly qualify it with a Workbook object.