TheSwamp

Code Red => VB(A) => Topic started by: whdjr on May 03, 2005, 12:10:08 PM

Title: How about a Tutorial
Post by: whdjr on May 03, 2005, 12:10:08 PM
Ok...we need a Teacher to sign up...
Title: How about a Tutorial
Post by: Oak3s on May 03, 2005, 12:37:17 PM
-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.
Title: How about a Tutorial
Post by: daron on May 03, 2005, 12:39:57 PM
You're welcome.
Title: How about a Tutorial
Post by: BAshworth on May 03, 2005, 12:46:49 PM
What kind of thing would you like to see?
Title: How about a Tutorial
Post by: Mark on May 03, 2005, 01:19:23 PM
I would like to see an introduction course on how to call/use separate functions. i.e. Private Subs and such.
Title: How about a Tutorial
Post by: BAshworth on May 03, 2005, 01:45:38 PM
Quote from: Mark Thomas
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?
Title: How about a Tutorial
Post by: Oak3s on May 03, 2005, 01:54:46 PM
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.
Title: How about a Tutorial
Post by: whdjr on May 03, 2005, 02:10:49 PM
How about: "Where do I start?".
Title: How about a Tutorial
Post by: Eloquintet on May 03, 2005, 02:29:23 PM
yeah i'd be interested in a vba tutorial as well so i vote yes also
Title: How about a Tutorial
Post by: CmdrDuh on May 03, 2005, 02:39:06 PM
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
Title: How about a Tutorial
Post by: daron on May 03, 2005, 02:41:00 PM
CmdrDuh, You are aware of the Learning Center, are you not? If not, talk to Mark. If so, sorry for jumping to conclusions.
Title: How about a Tutorial
Post by: CmdrDuh on May 03, 2005, 03:12:19 PM
Daron, I did not, and I have never tried logging into it.  No problem, as I'm still learning my way around TheSwamp
Title: How about a Tutorial
Post by: BAshworth on May 03, 2005, 03:38:27 PM
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.
Title: How about a Tutorial
Post by: daron on May 03, 2005, 04:47:42 PM
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.
Title: How about a Tutorial
Post by: Mark on May 03, 2005, 05:11:29 PM
Quote from: BAshworth
Quote from: Mark Thomas
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!!
Title: How about a Tutorial
Post by: MP on May 03, 2005, 05:20:22 PM
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.
Title: How about a Tutorial
Post by: jonesy on May 04, 2005, 08:48:49 AM
Quote from: CmdrDuh
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
Title: How about a Tutorial
Post by: ML on May 06, 2005, 03:13:33 PM
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
Title: How about a Tutorial
Post by: CmdrDuh on May 06, 2005, 03:15:22 PM
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
Title: How about a Tutorial
Post by: ML on May 06, 2005, 03:16:05 PM
Exactly!
Title: How about a Tutorial
Post by: ML on May 06, 2005, 11:27:02 PM
Also, navigating through The VBA help screens is very valuable. Can't tell you how many examples I have copied or borrowed from.