TheSwamp
Code Red => VB(A) => Topic started by: whdjr on May 03, 2005, 12:10:08 PM
-
Ok...we need a Teacher to sign up...
-
-raising his hand-
i would love to see a tutorial. i just finished my first exercise in VBA. ;) i changed my osmode from 0 to 71. it was pretty fun.
also, in raising my hand i dedicate my 100th post to thanking everyone who makes theSwamp a special place.
-
You're welcome.
-
What kind of thing would you like to see?
-
I would like to see an introduction course on how to call/use separate functions. i.e. Private Subs and such.
-
I would like to see an introduction course on how to call/use separate functions. i.e. Private Subs and such.
Kind of a rundown on the differences between Private, Public, Static, etc... and when/how to use a Sub versus a Function?
-
at the moment i have this book ~AutoCAD 2004 VBA - A programmer's referenceand~ i try to follow it as much as possible. what im finding hard is its not basic enough....for me that is :oops: i would like to see something broken down for TheSwamp users like the lisp course. i know these things take time and talent so i dont know if a request for such a thing would be accepted or acceptable for that matter. but i would very much appreciate the source of knowledge and the opprotunity to endulge in the language......basicly, if someone would find gratification in sharing there know-how with me and its free....i am interested. especially when it could make my job faster, and more accurate....and free like i already said. i am interested.
-
How about: "Where do I start?".
-
yeah i'd be interested in a vba tutorial as well so i vote yes also
-
OK, I guess I'll go public with what I'm doing. Jonesy had expressed an intrest a while back to learn VBA, and since no one jumped on it, I said I would help her. I'm putting together a small do-it-your-self-at-your-own-pace seminar based on what I know. (Which isn't much, but I tried to help)
I am currently putting together what I call a primer which starts with some concepts needed that I learned from VB, and apply that to VBA
-
CmdrDuh, You are aware of the Learning Center, are you not? If not, talk to Mark. If so, sorry for jumping to conclusions.
-
Daron, I did not, and I have never tried logging into it. No problem, as I'm still learning my way around TheSwamp
-
If you are looking for some very basic tutorials on how to get started, and learning some of the basic concepts, you could also try Afralisp.com. They have some beginner's tutorials on using VBA inside of AutoCAD.
Duh is good at these training setups, and if the rest of you also want a basic tutorial on getting AutoCAD to talk to outside programs (Access, Excel, etc....) then I'd be more than happy to write something up for you guys.
-
Talk to Mark about setting something up, if you're interested in setting up a course. They are by invitation only as I understand it, at this point.
-
I would like to see an introduction course on how to call/use separate functions. i.e. Private Subs and such.
Kind of a rundown on the differences between Private, Public, Static, etc... and when/how to use a Sub versus a Function?
Precisely!!
-
Quick summary:
Public - Make available to every module in a project.
Private - Available only to the current module. Typically used to hide or encapsulate implementation details. For example, you may have a Public wrapper for a private api declaration and implementation. Or, you may have a Public Get Property and a Private Let Property, making it oestensibly Read-Only outside the Class / Form.
Static - Use to retain values between calls, in other words, each call to the Sub / Function uses the same variable(s). Sometimes used to speed up critical code.
-
OK, I guess I'll go public with what I'm doing. Jonesy had expressed an intrest a while back to learn VBA, and since no one jumped on it, I said I would help her. I'm putting together a small do-it-your-self-at-your-own-pace seminar based on what I know. (Which isn't much, but I tried to help)
I am currently putting together what I call a primer which starts with some concepts needed that I learned from VB, and apply that to VBA
This offer is much appreciated. Thanks
I am looking forward to learning as much as I can, to make my life easier :D
-
I think people need to know how the vbamanager works, how to load a VBA project, how to access the macros, how to create a new module, name a module, save a project etc.
When I was starting, people would send me code or I would copy code from The Net but I didn't know what to do with it.
Once I learned how to make a Module, name it, paste the code in and save it, I was on my way.
Mark
-
I intend to cover those very topics b/c I know exactly what you mean. We got all this cool code, but couldn't make it work b/c we didn't know what to do with it
-
Exactly!
-
Also, navigating through The VBA help screens is very valuable. Can't tell you how many examples I have copied or borrowed from.