VBA Coding

[Prayder]

Is there a great book or website that could teach the slowest person in the world (me) the easiest way to code vb script?

 

[pr2-eugin]

A great website with loads of info : http://www.functionx.com/visualbasic/

 

[EternalMyrtle]

When I started using code, I was mostly self-taught (with the help of Google). I would want to do something and search the web for a solution and use code other people posted. Once you get some basic familiarity with the event handlers and the concept of a module, it is not as intimidating. Soon enough, I started to recognize the logic was able to write simple code on my own.

When that wasn't enough, I took a vb class at my local community college. I wouldn't recommend the book we used in class (it was ok) but if you do an Amazon search I am sure you can find something great. I would highly recommend taking a class, however, if you find you are not a natural at this. You can learn much more from someone who is an expert than you can on your own with only a book and the web as a guide.

 

[CJ_London]

Here are some suggestions

here are some links which may help
http://www.dummies.com/how-to/conten...r-dummies.html
http://www.youtube.com/watch?v=G9pqmd2PSYk
http://www.learnaccessvba.com/free_t...with_video.htm
http://allenbrowne.com/
__________________

 

[Simon_MT]

My advise is to use VBA as a tool when you need it use it. I would always write VB in modules rather than forms. Why here is a little script that renders any image on a form called ImageControl:

Function GetPicture()
    With CodeContextObject
        If GetPictureExist = True Then
            .[ImageControl].Visible = True
            .[ImageControl].Picture = GetPicturePath
        Else
            .[ImageControl].Visible = False
        End If
    End With
End Function

Simon