any vba tutorials out there?

[stupidz]

hi all~

i was exploring the marcos until i came across this vba thing. i couldn't find any vba tutorials through the net n i was wondering if there are any vba tutorials out there.

Thanks
cheers,
stupidz

[Shattered]

it largely depends on which vba you are looking for tutorials on, remembering that vba does differ slightly from program to program (well, the principles remain the same but you know what I mean).

The folowing may be some help :

For Access
FunctionX Tutorials


For Excel
Excel Training
Beyond Technology

General
VBA Tips
John Walenbach Links

[alex_read]

Also if you want to splash out, you can get the micorsoft books which have cd's of examples to go with their written examples to learn this...

The one I got (ok it's a bit outdated & has the 3 books rather than single) was "microsoft office developer edition resource kit" - there should be an xp version of this if you try a search on amazon etc.

[AznFuman]

Originally posted by alex_read
Also if you want to splash out, you can get the micorsoft books which have cd's of examples to go with their written examples to learn this...

The one I got (ok it's a bit outdated & has the 3 books rather than single) was "microsoft office developer edition resource kit" - there should be an xp version of this if you try a search on amazon etc.

Thats gonna be expensive!! as a volunteer coop student... you got more examples? lol... just excel is coo... thanx

[alex_read]

Depends really - I'm just saying if you can find the official ms developer ones they're excellent.

I wouldn't have got this myself & shelled out £150 fot the actual thing - saw it in a discount bookshop with a tear in the side for about £30!

They do an Excel one though as part of this set that's all...

[AznFuman]

Originally posted by alex_read
Depends really - I'm just saying if you can find the official ms developer ones they're excellent.

I wouldn't have got this myself & shelled out £150 fot the actual thing - saw it in a discount bookshop with a tear in the side for about £30!

They do an Excel one though as part of this set that's all...

tats 30 pounds?? Sorry, im stupid with currency! lol...
but im at -11 dollars for the month! stupid gas money...
stupid cars.... stupid places are sooo far... lol

thanx alot though, i'll check it out when i get my pay check

[alex_read]

You might want to scroll to the bottom of this one : http://www.experts-exchange.com/Appl..._20697828.html and check out the links there.

On top of that, it might be worth going through some of the old posts in the VBA forum here too to try & learn this - apart from them, the internet hasn't got any really decent resources to learn this from scratch from what I've found - even the MS office developer site is pretty bad for this!

[AznFuman]

Originally posted by alex_read
You might want to scroll to the bottom of this one : http://www.experts-exchange.com/Appl..._20697828.html and check out the links there.

On top of that, it might be worth going through some of the old posts in the VBA forum here too to try & learn this - apart from them, the internet hasn't got any really decent resources to learn this from scratch from what I've found - even the MS office developer site is pretty bad for this!

hahhaha yah... the link the guy has above, doesnt work... at least not from this ip, im at http://www.beyondtechnology.com/vba.shtml


btw... wats the difference between the file formats
.shtml, .htm, .html ........... they all seem to be html codes....

[AznFuman]

im trying to use excel to link it to mysql via odbc....
tats my current coop assignment...
god its a pain... lol
but i was looking through some post and found this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If (ActiveCell.Address = "$A$1") Then
Cells(1, 2).Select
ElseIf (ActiveCell.Address = "$A$2") Then
Cells(2, 2).Select
End If
End Sub

haha tats cool code.... tat'll #@$! someone off
e.g. if u click on 1,1 u goes to (1000,1)... lol
it'll be a funny pranq... lol

[alex_read]

well I guess - it also has it's good points though - were you using those bottom 4 links on that site I gave you? these worked for me

[AznFuman]

yah it works... lol sorry
i meant the ones from shatter
i need to find stuff related to odbc
ahhhhhhhh shooot me,,,,

[Shattered]

Originally posted by AznFuman
hahhaha yah... the link the guy has above, doesnt work... at least not from this ip, im at http://www.beyondtechnology.com/vba.shtml

Not sure why it wopuldn't work from your ip? tested the link now from four different machines and all managed to access it easy enough...

oh well