Odd question: Anyone have a collection of resources to use when teaching someone VBA from scratch? I started them off with CodeAcademy (learning Python purely for learning basic syntax of programming, as well as variables, loops, etc), and I often refer people to WiseOwl for beginner tutorials, but thats about where my resources end.
Ideally, resources that allow them to practice and play around with stuff beyond just making the same charts or tables repeatedly.
@Mat'sMug What's it called? The part of General Settings, Todo Settings, ... that lets the lefthand part display the window for what's selected? Just Form/Window?
If I could summarize a new-user doc in one page or less I would be selling it lol.
I'm a terrible coding instructor though. I had to make a simple example for a new hire and I ended up using a Dictionary and some arrays and something else as well. He was completely lost and somewhat terrified.
Once they have something set up what involves ton of foo.select with Selection.Bar you can refactor the .select and Selection out for them and show them how to do it without the middleman.
@IvenBach The important part is getting them to understanding why. And also seeing the value in being able to automate stuff. The stuff I know is literally months (if not a year) beyond Don't use Select but I dont have months of patience to get them there lol.
@IvenBach It was a joke lol.
@IvenBach I'm not even sure I could write the first part of that lesson yet anyways. I am almost there, but not quite.
I did make my own stupid pointless game where a list of names is inputted and then a die is rolled for each player where they can get between x and y for a score, and there's a Z% chance of them not getting a turn. It was kind of fun to see the results.
The format argument can have any of the following settings:
Constant Value Description
TristateUseDefault 2 Opens the file using the system default.
TristateTrue 1 Opens the file as Unicode.
TristateFalse 0 Opens the file as ASCII.
I heard there's this site, uh, gugle, wait no, goo-goal - no wait I got it - it's GOOGLE - awesome little thing, you type "scripting dictionary" and it gets you everything you ever dreamed to know about 'em. — Mat's Mug6 secs ago
@FreeMan @puzzlepiece87 @BrandonBarney The Step command fails because some other non-steppable code is handling events. That could be a VBE add-in, or an Excel COM add-in, or another open workbook that is protected. In my case it was Acrobat PDFMaker (a COM add-in in Excel). Disable all of your Excel COM add-ins, close all workbooks except the one you're debugging, and the Step command should work. Then, re-enable various COM-addins and workbooks until you find the culprit.
in ProceduralModuleDeclaration one constructor takes a ComStruct parameter and sets the IsPrivateModule property based on this parameter's IsRestricted property
@Hosch250 Really helpful examples in your SOLID examples. It's going to take me a while to, by default, think in this manner but I can see the applicability and use.
@Hosch250 You're probably right, but IIRC, most gun deaths are of people in the same household as the gun, whether it's the spouse, or the children. Accidents are still homicides, and unfortunately too many kids get access to guns and don't know what they're doing.
> The AsEnumerable<TSource>(IEnumerable<TSource>) method has no effect other than to change the compile-time type of source from a type that implements IEnumerable<T> to IEnumerable<T> itself.
I think that highschoolers should receive mandatory gun safety classes, where they are actually taught to shoot a gun, not just the abstract "guns are dangerous".
public class List<T> : IList<T>, ICollection<T>, IEnumerable<T>, IEnumerable, IList, ICollection, IReadOnlyList<T>, IReadOnlyCollection<T> I see that on MSDN
So instead of having a List<T> which itself implements IEnumerable<T> if you wanted to disrobe/strip it (lack a better term) of the list stuff features you can and make it just an IEnumerable<T>?
@Hosch250 That’s correct... NRA members are the trained and responsible ones. Yeah, they shoot other people- but only in self defense. If the others weren’t trying to kill them, they wouldn’t shoot anyone.
But, if I do buy one, it is almost certainly going to be because the government tries to ban them, because freedom of speech and the freedom to a quick trial is next.
In the Code Explorer, if you right-click on a component, you can Export the selected item. I want to change it so that when you click on a Project, it exports all the components in that project.
1) I have a fair idea how to do the programming for the "work" aspect of that, but I'd like to ask, what's the best way to do that (which I see you already eluded to)
and 2) How would I go about changing the menu item to say "Export All" instead of "Export"?
@shadowofsilicon hmm, IIRC the context menu is the same regardless of what node is selected. You could bind the menu item's text to a property getter in the ViewModel that returns the correct resource string depending on the selected node
You'll find the ViewModel class at the top of the xaml markup, in the d:datacontext tag
WPF is all about bindings
and bindings are all about the datacontext. well, mostly anyway (you can have bindings to other xaml elements, for example.. but most of the time you'll just bind to a property in the VM)
VBA Rubberducking
VBA Rubberducking