Poll

Would you like a VBA Tutorial?

Yes
18 (100%)
No
0 (0%)

Total Members Voted: 9

Voting closed: May 03, 2005, 12:10:08 PM

Author Topic: How about a Tutorial  (Read 5332 times)

0 Members and 1 Guest are viewing this topic.

whdjr

  • Guest
How about a Tutorial
« on: May 03, 2005, 12:10:08 PM »
Ok...we need a Teacher to sign up...

Oak3s

  • Bull Frog
  • Posts: 321
How about a Tutorial
« Reply #1 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.

"Freedom is not defined by safety. Freedom is Defined by the ability of citizens to live without government interference"
-- Ron Paul

daron

  • Guest
How about a Tutorial
« Reply #2 on: May 03, 2005, 12:39:57 PM »
You're welcome.

BAshworth

  • Guest
How about a Tutorial
« Reply #3 on: May 03, 2005, 12:46:49 PM »
What kind of thing would you like to see?

Mark

  • Custom Title
  • Seagull
  • Posts: 28683
How about a Tutorial
« Reply #4 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.
TheSwamp.org  (serving the CAD community since 2003)

BAshworth

  • Guest
How about a Tutorial
« Reply #5 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?

Oak3s

  • Bull Frog
  • Posts: 321
How about a Tutorial
« Reply #6 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.

"Freedom is not defined by safety. Freedom is Defined by the ability of citizens to live without government interference"
-- Ron Paul

whdjr

  • Guest
How about a Tutorial
« Reply #7 on: May 03, 2005, 02:10:49 PM »
How about: "Where do I start?".

Eloquintet

  • Gator
  • Posts: 3206
How about a Tutorial
« Reply #8 on: May 03, 2005, 02:29:23 PM »
yeah i'd be interested in a vba tutorial as well so i vote yes also
Dan

AutoCAD Architecture 2015

CmdrDuh

  • Automatic Duh Generator
  • King Gator
  • Posts: 4039
How about a Tutorial
« Reply #9 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
Everyone has a photographic memory, Some just don't have film.
They say money can't buy happiness, but it can buy Bacon and that's a close second

daron

  • Guest
How about a Tutorial
« Reply #10 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.

CmdrDuh

  • Automatic Duh Generator
  • King Gator
  • Posts: 4039
How about a Tutorial
« Reply #11 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
Everyone has a photographic memory, Some just don't have film.
They say money can't buy happiness, but it can buy Bacon and that's a close second

BAshworth

  • Guest
How about a Tutorial
« Reply #12 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.

daron

  • Guest
How about a Tutorial
« Reply #13 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.

Mark

  • Custom Title
  • Seagull
  • Posts: 28683
How about a Tutorial
« Reply #14 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!!
TheSwamp.org  (serving the CAD community since 2003)

MP

  • Seagull
  • Posts: 17400
How about a Tutorial
« Reply #15 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.
\|// Set goal. Experiment tirelessly until
|Oo| practice has become expertise.  Loop.
|- | LinkedIn | Dropbox

jonesy

  • SuperMod
  • Seagull
  • Posts: 15502
How about a Tutorial
« Reply #16 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
Thanks for explaining the word "many" to me, it means a lot.

ML

  • Guest
How about a Tutorial
« Reply #17 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

CmdrDuh

  • Automatic Duh Generator
  • King Gator
  • Posts: 4039
How about a Tutorial
« Reply #18 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
Everyone has a photographic memory, Some just don't have film.
They say money can't buy happiness, but it can buy Bacon and that's a close second

ML

  • Guest
How about a Tutorial
« Reply #19 on: May 06, 2005, 03:16:05 PM »
Exactly!

ML

  • Guest
How about a Tutorial
« Reply #20 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.