Visual Basic Tutorial

[vegyjones]

If I was looking for a Vsual Basic tutorial to be used in Excel,

what should I be looking for in google.

I have seen a tutorial that seems to show VB as a seperate identity,
whereas mine is to be used strictly in excel to create macros!

And before anyone says it, Yes, I may very well be aiming too high! :D

[Huggy2000]

Try searching for 'Visual Basic for Appications' (VBA). It's different to VB (VB), but it's in Excel :D


Don't click on this though ...
http://www.vba.va.gov/
You'll get the wrong thing

[Win2Win]

Just buy the dummies guide to tight twit :)

[mathare]

Or just ask me how to do whatever it is you're trying to do...

[vegyjones]

Thanks Huggy.

That is true Mat...
but I am not after anything specific, just wanted to know how to do what you do! :)

I did find a little free tutorial.
But it comes in weekly installments! :(

[ray7]

Have you got a link for the free tutorial Vegy

[vegyjones]

Err, I'll post it when I get home Ray!

[mathare]

That is true Mat...
but I am not after anything specific, just wanted to know how to do what you do! :)There is a lot of my code available to W2W members (and probably some to non-members). A decent starting point would be to read some of that and see if you can work out what it is doing.

The syntax of VBA is easy to understand, far more so than some other languages I have used.

The debugger in the VBA Editor is handy too. Pressing F8 will step through the code line by line and by adding watches to variables (right click, Add Watch and enter variable name) you can see how the variables are changed as the code runs.

I'm quite happy to write a fully-commented simple program if there is sufficient demand for it. But by far and away the easiest way to learn any form of programming is to have a specific goal in mind rather than just trying to pick up the language all at once. Things like betting records including ROIs, t-values etc are a great way to get started.

[ray7]

Thanks Vegy

Mat anything you could put up would be helpful. I used to program in Sinclair Basic :yikes: and machine code back in the 80s but have not done anything since so need to keep it simple :)

[Win2Win]

vBA isn't far off Sinclair Basic.....same principles.....machine code :D....I loved that :doh I used to use it in CPM :yikes: ....now that is a blast from the past. An O/S that was MUCH better than MSDOS.

[plater]

Here's a quick google for links. :wiggle:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=302
http://www.mindspring.com/~tflynn/excelvba.html
http://www.ozgrid.com/VBA/default.htm
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm

[ray7]

Thanks Plater, first one is very interesting will have a proper look at the others tonight when I have more time.

[vegyjones]

http://spreadsheets.about.com/cs/exceladvanced/a/vba1index.htm

Herte's the one I found Ray!

Shouldn't take long to complete the steps up to Lesson 3,
Just gotta wait for lesson 4 now :(

[ray7]

Thanks Vegy