tutorials for Visual Studio or Excel VB Macros

[UofA_Hogs]

I have been trying to learn as much as possible about writing VB script in Excel and Access. I have a pretty good understanding of both programs and can record macros just fine, but I really am trying to get better and gain a thorough knowledge of VB script. Is there any (preferably free) training aids, tutorials, workbooks, or any thing else that can help me get more familiar with and learn VB for excel and access?

Thanks

 

[UofA_Hogs]

Just for Clarification, I am not opposed to paying for material, I just want to increase my knowledge and understanding.

 

[Colin Legg]

Hi,

I'm out of touch with beginner/beginner to intermediate level material so I can't make a solid recommendation, but I'll just mention that Visual Basic For Applications (VBA) and Visual Basic Script (VBS) are different things. VBA comes integrated with (most versions of) Excel and Access, so that's the one you want, not VB Script.

 

[shg]

Are you referring to VBA or VB Script? They are similar, but are different languages.

Hiker95 posts a good list from time to time; one is here:http://www.mrexcel.com/forum/showthread.php?p=2827706#post2827706