wilmott.com

If you plan to do some more programming, learn VB6, VBA should be easy as pie if you know VB6 or VB.Net.VBA is a language targetting an audience which does not know about programming or who are in needs of quick fixes. VB6 and VB.Net are real programming languages mostly useful for RAD and for people who want an easy to learn programming language.If you want to do some serious programming, you should go for languages like C++ although the learning curve is alot steeper.

VB and VBA r the same language as far as i'm concerned

Well part of the problem is that the question posed is too open - I tend to pay less attention to worrying about user-forms or complicated front-ends so the core programming elements are pretty much the same in VBA or VB6 - my advice would be to start with VBA first then decide if VB6 or C++ is better after that - either would be a lot more effort than VBA

Geepers, one reply for VB6 first, one reply saying they're both the same (language-wise) and one reply for VBA first... now I'm really confused.

QuoteOriginally posted by: jnick99 now I'm really confused.that should hint u that it doesnt matter what u do, they're the same

jnick,VB6 is a programming language, for creating applications from scratch. VBA is the same programming language, but in the context of a particular application (usually Excel), meaning that you can access and control that application by running some code that you have written (what a novice would call a "macro"). So yeah, they're the same language, but when you talk about VB6 vs VBA you are talking about doing quite different things in the same languageIf you want to learn from scratch, IMO it is undoubtably easier to start in your comfort zone, in the context of Excel/VBA where you don't have the overhead of designing all the front-end of the application etc before you can start writing code that does stuff. Of course you should also learn about VB forms, classes, events, controls, and all that other stuff that has nothing to do with excel, but you can learn this in the VBA development environment before graduating to VB6 proper.VB.Net superficially seems quite similar to VB6, but is different enough to be considered a different language.

Strictly speaking VBA is a clone of VB5, not 6Although the syntax of VBA is pretty much the same as VB5/6 the style of programming is very different.In VB, your code is in control of things, and "owns" objects like controls.In VBA, the normal style is to respond to what Excel wants, and slot into it's way of doing things.

QuoteOriginally posted by: DCFCStrictly speaking VBA is a clone of VB5, not 6in excel 2000 vba, i can still use stuff from vb6 that wasn't in 5, like the Join and Split string functions. i'm not aware of anything specific available in vb6 that is not in vba?

VBA is a clone of VB, I did at one point have the official MS document on the differences, but that got binned years ago.VBA was written by different people.

Well I attempted to learn some VBA and was having a hard time grasping it. Then I read somewhere that if I acquired basic programming skills in VB that it would be very beneficial in learning to use VBA. But now I learn that VB is going to be much more complex than VBA. So I don't know, perhaps I just need to give VBA another try. Anyone wanna give me private tutoring?

if excel vba is your target, rather than writing applications in vb, then it's relatively easy to get started...(1) Google for "Excel VBA Tutorial", you're bound to find something useful(2) Write your own custom functions in excel, for things like linear interpolation or Black Scholes formulas(3) use the macro recorder in excel to record some task, then go and look at the code that has been recorded & try to figure out what's going on & write it again yourself but better(4) Use the vba help facility; it's pretty good. none of that is going to make you a particularly good VBA programmer, but it's a good start to understanding how vba and excel interact. once you start getting the hang of it you can pick up a book and teach yourself properly.