Learning Visual Basic

**The_Doctor** · 06-12-2005, 15:52

In case you didn't already know, the visual basic in excel is different from both visual basic 6, and the current bersion of the language, vb .net

I know that the Excel version is different.

What is the difference between VB6 and .net?

**Laridus Konivaich** · 06-12-2005, 17:44

Originally Posted by Martinus

What is the difference between VB6 and .net?

Spelling?

VB6 is older, and will soon no longer be supported by Microsoft, .NEt is newer (2003) and has become a fully object oriented language, which 6 was not. For example:

Code:

msgbox "Hi, welcome to my program!", "Welcome!"

versus:

messagebox.show("Hi, welcome to my program!", "Welcome!")

The differences, at least from what I have seen, are not too difficult to overcome, at least moving from 6 in .net, but what you should probably do is find out which version you will be learing in the class next year, so that you know what you should study on your own.

**The_Doctor** · 06-12-2005, 17:58

I found the hand-outs from last year and the guide they give you is about version 5.

http://www.edexcel.org.uk/VirtualContent/29839.pdf

This is the course I am doing. You don't all the units.

I did 1, 2 ,3, 9, 12 and 13.

I will be doing 4, 5, 6, 7, 14 and 16.

**TonkaToys** · 06-13-2005, 08:45

Standard VB is pretty straightforward if you've ever done any programming. It starts getting "fun" when you have to call Excel functions, or DB functions or API functions, although all of that is much easier now in .net.
SAMS do a good range of books, but really if you understand logic (if then, for next, select case, while wend, etc) then you only really need a reference book.
Good luck.

Ta-ra

**The_Doctor** · 06-13-2005, 17:37

I bought Visual Basic 6 for Dummies.

**The_Doctor** · 06-13-2005, 18:06

Oh great, the CD that came with the book does not have VB6 on it. The source code on the CD does not work with the VBA on Excel.

Is there is way to make it work on VBA?

If not,

Where can a get a copy of VB6?
Is it expensive?
It so, how can I get it for free? (the book cost £30, I do not want to pay a lot for it.)

**TonkaToys** · 06-14-2005, 08:42

The VB6 source code should be similar to VBA... what version of Excel are you using in case that makes a difference?
Actually, it could be good practice for you to take a simple piece of code that doesn't work, run it through the debugger and then try to fix the errors. That might be a good way of getting your head around it.
What type of errors are appearing? Perhaps the .Org can help.
I don't think you can get VB6 for free, legally.