Sample Code Publication

[Denny57]

Does anyone know of a publication that provides readily explained samples of code that would benefit those non-programmers / software developers amongst us and that helps to understand Excel VBA and some of the most frequently used and / or required actions.

I have a number of reference books , some for beginners others are more in-depth, but I can never seem to be able to find the simple solutions to requirements.

I have spent hours trying to resolve simple issues such as formatting a textbox into Currency, automatically running macros / modules when a User Form is opened and trying to copy data into a large number of cells without having to create a separate line of code for each textbox. Unless you are fluent in VBA then trying to find a solution is a minefield. (I have a solution for calling from an Array of Columns and a range of rows, but this code cannot be readily adapted where the information for each IF condition where the matching to consecutively named TextBoxes need to be applied by rows and not columns, as the syntax and code is different but finding the correct information is almost impossible for us novices

Many thanks

 

[Micron]

IMO, since there are thousands upon thousands of bits of information for objects and their methods, properties and events I'm going to say there's no easy way to connect what anyone wants to do with all the millions of possible solutions. It takes time to learn the basics for any Office application, which seems to me to be the foundation of what you're trying to research. I rely heavily on Google and M$ documentation on the object models for Office apps and I have to believe that without that foundation, it is hard to find info related to your needs because you don't always know what questions to ask. For those situations, I find that search engines are the best place to start - especially if they present you with alternate suggestions on the question. Those suggestions might be better formed for the question you're asking.
This link might help, but I think success largely depends on knowing something about what you want to find.

Books are great and usually explain things well, but they are not usually sources for quick answers to issues. They're more like long term courses but are probably a good option for rounding out your knowledge.