Results 1 to 5 of 5

Thread: VBA Explained

  1. #1
    Join Date
    Mar 2003
    Posts
    225

    Unanswered: VBA Explained

    i want to try and get a better understanding of VBA, i don't understand public, private, global etc...

    where i should put what and where...

    what i can use what i can't use....

    error handling etc..

    is there a good website, book or refernce point that explains from scratch how to use and write VBA please

    cheers

    Andy

  2. #2
    Join Date
    Jun 2002
    Location
    Saudi Arabia / Philippines
    Posts
    126
    From what you write I would recommend "VBA For Dummies". Even if you have prior programming experience in another language, stay with it. It's one of the better "Dummies" books and the humour is not too bad.
    Rod

    fe_rod@hotmail.com

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Global and Public Variables are the same, the variable will be seen and known in any Module or Class Module

    Private will be only seen where it is defiend and will be eliminated from the memory when the sub or function is executed.

    Static will retain its value when you enter the sub or function once again

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    have a look at this.

    it's A95/DAO but the fundamentals haven't changed (scope, events, error handling, forms, tables, queries, reports).
    ...and if you like Alison's style you can always buy her book that goes with your A-rev.

    izy
    currently using SS 2008R2

  5. #5
    Join Date
    Jan 2004
    Location
    Myanmar (Burma)
    Posts
    42

    Wink VBA for which application?

    I used VBA in excel and access.
    I've little knowledge about object oriented programming and VB.

    I did'nt read any books about VBA in Access.
    but I've a book about VBA for excel.
    it is a good one.
    'Excel 2002 Power Programming with VBA'
    Author: John Walkenbach
    Following url is author's page
    http://www.j-walk.com/

    BTW, 'hammbakka' seem GURU in Access and Object Oriented Programming.
    he helped and guided me several times.

    have a nice day
    Last edited by mmlatt; 10-07-04 at 07:18.
    Cyber : The easiest place to make huge mistake.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •