What is the best way to learn Visual Basic?
- Thread starter buster
- Start date
- Status
Integrated Development Environment.
Microsoft ussualy gives out their "express" / IDE for free for basic programing.
Programing is just matter of having sets of labs to do that increase difficulty. You read and google stuff until you grasp it and move on to next idea to learn. In my college education that has been how I learned, not neccesary a whole alot from siting in lecture.
Programing is just matter of having sets of labs to do that increase difficulty. You read and google stuff until you grasp it and move on to next idea to learn. In my college education that has been how I learned, not neccesary a whole alot from siting in lecture.
VB with Excel is Visual Basic for Applications, more commonly called "VBA".
John Walkenbach is by far and away the most well known Excel author. His "VBA for dummies" book is a good starting point in learning the programming end. All of his books are well-written and easy to read. His website is www.spreadsheetpage.com and it offers lots of good Excel and VBA tips. cPearson.com is another good Excel site with numerous programming examples.
My recommendation is to learn Excel very well before learning the VBA programming. I've seen too many "programmers" attempt to write elaborate code to do something that Excel has built in. This is usually because they are not aware of the functionality of the product.
Let me know if you need any help scripting VBA code. I have been writing it full time for the past 19 years.
John Walkenbach is by far and away the most well known Excel author. His "VBA for dummies" book is a good starting point in learning the programming end. All of his books are well-written and easy to read. His website is www.spreadsheetpage.com and it offers lots of good Excel and VBA tips. cPearson.com is another good Excel site with numerous programming examples.
My recommendation is to learn Excel very well before learning the VBA programming. I've seen too many "programmers" attempt to write elaborate code to do something that Excel has built in. This is usually because they are not aware of the functionality of the product.
Let me know if you need any help scripting VBA code. I have been writing it full time for the past 19 years.
- Status
