Teaching myself VB

[Y'all Qaeda]

I want to start teaching myself some visual basic, basically to be more proficient in excel - which is weird I know.
Anyone have any good *free* books to recommend? I did some Turbo Pascal in high school, but I doubt it'll be of much help.

Links to said books will be appreciated.

 

[Skywalker42]

http://files.zipsites.ru/books/programming/VisualBasic/Visual%20Basic%206%20Black%20Book.pdf

Just Google:
Programming Visual Basic
Learning Visual Basic
etc
etc

Too many results to list...

And if you are going to use it with Excel also google Visual Basic for Applications.

EDIT: Also have look here

 

[deweyzeph]

Sorry to be pedantic, but if you want to write macros in Excel then you need to learn VBA (Visual Basic for Applications), not VB. There is a subtle but important difference between the two.

 

[Y'all Qaeda]

Sorry to be pedantic, but if you want to write macros in Excel then you need to learn VBA (Visual Basic for Applications), not VB. There is a subtle but important difference between the two.

I've noticed that. But the way I figure, if I start with VB and then move to VBA I'll have a better understanding of the working of it etc. plus I'll probably know more commands so win win I thought.

 

[deweyzeph]

The problem is that the latest flavour of VB is VB.NET, while VBA still uses the old syntax of VB, similar to VB5 and VB6. Most of the literature out there on the Internet for VB is going to be for VB.NET, and there is a big difference in syntax between VB.NET and VB5, VB6 and VBA.

Plus VB.NET uses the .NET framework and is much more object-orientated than VBA, which is still very much a procedural language.